SI.EXPANDWAREHOUSERANGE

Overview

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

CODE

=SI.EXPANDWAREHOUSERANGE(
    ConnectionName, 
    Range, 
    IncludeInactive
)

The SI. EXPANDWAREHOUSE 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 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:

CODE

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

Description

Returns all Warehouse IDs.

Results

CODE

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

Description

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

Results

Assuming the following configuration within Sage Intacct:

CODE

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

Description

Returns all active Warehouse IDs.

Results