SI.EXPANDDEPARTMENTRANGE

Overview

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

=SI.EXPANDDEPARTMENTRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDDEPARTMENT RANGE 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 Department IDs to be displayed. See Filtering Velixo Functions.
`Status`	Optional	An indicator of which status(es) of departments to include in the results. `"A"` - active `"I"` - inactive `"N"` - Active non-posting (a combination may be used - e.g., `"AN"` or `"NI"`) (available in version 2023.8 and higher)

Assuming the following configuration within Sage Intacct:

=SI.EXPANDDEPARTMENTRANGE(
    "Sage"
)
or
=SI.EXPANDDEPARTMENTRANGE(
    "Sage",
    "*"
)

Description

Returns all Department IDs.

Results

=SI.EXPANDDEPARTMENTRANGE(
    "Sage",
    "100:300"
)

Description

Returns all Department IDs between 100 and 300 (inclusive).

Results

Assuming the following configuration within Sage Intacct:

=SI.EXPANDDEPARTMENTRANGE(
    "Sage",
    ,
    "AN"
)

Description

Returns all Active or Active non-posting Department IDs defined in Sage Intacct:

Results

The InactiveDepartment is not included