SI.EXPANDWAREHOUSERANGE

Overview

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

=SI.EXPANDWAREHOUSERANGE(
    ConnectionName, 
    Range, 
    IncludeInactive
)

The SI. EXPANDWAREHOUSE 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 Warehouse IDs to be displayed. See Filtering Velixo Functions.
`IncludeInactive`	Optional	`TRUE` (default) or `FALSE` Determines whether or not to include entries with a Status field set to Inactive in the results. (available in version 2023.8 and higher)

Assuming the following configuration within Sage Intacct:

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

Description

Returns all Warehouse IDs.

Results

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

Description

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

Results

Assuming the following configuration within Sage Intacct:

=SI.EXPANDWAREHOUSERANGE(
    "Sage",
    ,
    FALSE
)

Description

Returns all active Warehouse IDs.

Results