SI.EXPANDCLASSRANGE
Overview
The SI.EXPANDCLASSRANGE function returns an array containing one or more Sage Intacct Class IDs (based on the specified range).
Syntax
=SI.EXPANDCLASSRANGE(ConnectionName, Range, Status)Arguments
The SI. EXPANDCLASSRANGE function uses the following arguments:
Argument | Required/ Optional | Description |
| Required | The name of the connection as configured in theConnection Manager |
| Optional | A range filtering specifying the Class IDs to be displayed. See Filtering Velixo Functions |
| Optional | Determines whether to limit the results based on the contents of the Status field values Options:
(available in version 2023.9 and higher) |
Examples
Example 1
=SI.EXPANDCLASSRANGE("Sage","*")Description
Returns the Class ID for every class defined in the specified connection:
Results
Example 2
=SI.EXPANDCLASSRANGE("Sage","*;-200")Description
Returns every Class ID *except* for Class 200
Results
Example 3
=SI.EXPANDCLASSRANGE("Sage","100:500")Description
Returns every Class ID between 100 and 500 (inclusive).
Results
Example 4
Assuming the following configuration within Sage Intacct:
=SI.EXPANDCLASSRANGE("Sage",,FALSE)
Description
Returns every active Class ID defined in Sage Intacct.
Results
Inactive class 400 is not included