ACU.EXPANDPROJECTTASKRANGE

Overview

The ACU.EXPANDPROJECTTASKRANGE function returns the sorted project task IDs matching the search criterion, defined within Acumatica.

Results can be used with functions like PROJECTBUDGETAMOUNT, WRITEBACKPROJECTCOSTPROJECTION, or others.

CODE

=ACU.EXPANDPROJECTTASKRANGE(
    ConnectionName, 
    Project,
    Task
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Project`	Required	Project ID. Use EXPANDPROJECTRANGE to list available values.
`Task`	Optional	A search expression for project task IDs, uses Velixo filtering techniques. If not specified, returns all tasks.

CODE

=ACU.EXPANDPROJECTTASKRANGE(
    "Acumatica",
    "REVREC01"
)

Description: Returns a list of project task IDs available in the REVREC01 project for the Acumatica connection.