Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
This function applies to Sage Intacct connections only.
Description
The SI.EXPANDTASKRANGE function returns all general ledger account numbers within the specified range.
Syntax
SI.EXPANDTASKRANGE(ConnectionName, ProjectRange, TaskRange, TaskType)
The SI. EXPANDTASKRANGE function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
ProjectRange | Optional | The range of project codes to examine to find the task codes to include in the results. See our article on including multiple parameter values |
TaskRange | Optional | The range of task codes to include in the results. See our article on including multiple parameter values |
TaskType | Optional | The type of task(s) to be displayed:
|
Examples
Example #1
=SI.EXPANDTASKRANGE("Sage", "*", "*")
Description
Returns all task codes for all projects.
Result
Example #2
=SI.EXPANDACCOUNTRANGE("Sage", "10000:10025")
Description
Returns all task codes used within projects 10000 through 10025.
Results
Example #3
=SI.EXPANDACCOUNTRANGE("Sage",,"100:900;-300")
Description
Returns all task codes between 100 and 900 (inclusive) except code 300.
Results
Example #4
Given this structure defined within Sage Intacct:
=SI.EXPANDTASKRANGE("Sage","coyr-0017","R3-03???",2)
Description
Returns all Parent task codes beginning with "R3-03" with a Job ID of COYR-0017.
Results
