SI.EXPANDCUSTOMERRANGE

Overview

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

=SI.EXPANDCUSTOMERRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDCUSTOMERRANGE 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 Customer IDs to be displayed. See Filtering Velixo Functions.
`Status`	Optional	An indicator of which status(es) of customers 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)

=SI.EXPANDCUSTOMERRANGE(
    "Sage",
    "*"
)

Description

Returns the Customer ID for every customer in the specified connection.

Results

=SI.EXPANDCUSTOMERRANGE(
    "Sage",
    "*;-100??"
)

Description

Returns every Customer ID which does not start with 100.

Results

=SI.EXPANDCUSTOMERRANGE(
    "Sage",
    "10100:20000"
)

Description

Returns every Customer ID between 10100 and 20000 (inclusive).

Results

Assuming the following configuration within Sage Intacct:

=SI.EXPANDCUSTOMERRANGE(
    "Sage",
    "10100:20000",
    "NI"
)

Description

Returns every non-inactive Customer ID between 10060 and 10200 (inclusive).

Results

Inactive customers 10082 and 10083 are not included