SI.EXPANDDEPARTMENTRANGE

Overview

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

CODE

=SI.EXPANDDEPARTMENTRANGE(ConnectionName, Range, Status)

The SI. EXPANDDEPARTMENT RANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`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:

CODE

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

Description

Returns all Department IDs.

Results

CODE

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

Description

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

Results

Assuming the following configuration within Sage Intacct:

CODE

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

Description

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

Results

The InactiveDepartment is not included