SI.EXPANDLOCATIONRANGE

Overview

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

CODE

=SI.EXPANDLOCATIONRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDLOCATIONRANGE 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 Location IDs to be displayed. See Filtering Velixo Functions.
`Status`	Optional	Determines which entities are included in the results. Available values: `A` - records with a Status field set to Active `N` - records with a Status field set to Active non-posting `I` - records with a Status field set to Inactive A combination of values can be used (e.g., `"ANI"`). By default, all records with any status are included in the results. (available in version 2023.10 and higher)

Assuming the following configuration within Sage Intacct:

CODE

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

Description

Returns all Location IDs.

Results

CODE

=SI.EXPANDLOCATIONRANGE(
    "Sage",
    "9??"
)

Description

Returns all of the three-digit Location IDs with start with the digit 9.

Results

CODE

=SI.EXPANDLOCATIONRANGE(
    "Sage",
    "100:300;900:999"
)

Description

Returns all Location IDs between 100 and 300 (inclusive) and between 900 and 999 (inclusive).

Results

Assuming the following configuration within Sage Intacct:

CODE

=SI.EXPANDLOCATIONRANGE(
    "Sage",
    ,
    "A"
)

Description

Returns all active Location IDs defined within Sage Intacct.

Results

Inactive location 900 is not included