SI.EXPANDCLASSRANGE

Overview

The SI.EXPANDCLASSRANGE function returns an array containing one or more Sage Intacct Class IDs (based on the specified range).

=SI.EXPANDCLASSRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDCLASSRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`Range`	Optional	A range filtering specifying the Class IDs to be displayed. See Filtering Velixo Functions
`Status`	Optional	Determines whether to limit the results based on the contents of the Status field values Options: `"A"` - active `"N"` - active, non-posting `"I"` - inactive blank (empty value) - include all statuses (available in version 2023.9 and higher)

=SI.EXPANDCLASSRANGE(
    "Sage",
    "*"
)

Description

Returns the Class ID for every class defined in the specified connection:

Results

=SI.EXPANDCLASSRANGE(
    "Sage",
    "*;-200"
)

Description

Returns every Class ID *except* for Class 200

Results

=SI.EXPANDCLASSRANGE(
    "Sage",
    "100:500"
)

Description

Returns every Class ID between 100 and 500 (inclusive).

Results

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