SI.EXPANDWAREHOUSERANGE
Overview
The SI.EXPANDWAREHOUSERANGE function returns an array containing one or more Sage Intacct Warehouse IDs (based on the specified range).
Syntax
=SI.EXPANDWAREHOUSERANGE(ConnectionName, Range, IncludeInactive)Arguments
The SI. EXPANDWAREHOUSE RANGE function uses the following arguments:
Argument | Required/ Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Optional | A range filtering specifying the Warehouse IDs to be displayed. See Filtering Velixo Functions. |
| Optional |
Determines whether or not to include entries with a Status field set to Inactive in the results. (available in version 2023.8 and higher) |
Examples
Assuming the following configuration within Sage Intacct:
Example 1
=SI.EXPANDWAREHOUSERANGE("Sage")
or
=SI.EXPANDWAREHOUSERANGE("Sage","*")Description
Returns all Warehouse IDs.
Results
Example 2
=SI.EXPANDWAREHOUSERANGE("Sage","100:300")Description
Returns all Warehouse IDs between 100 and 300 (inclusive).
Results
Example 3
Assuming the following configuration within Sage Intacct:
=SI.EXPANDWAREHOUSERANGE("Sage",,FALSE)Description
Returns all active Warehouse IDs.
Results
