SI.EXPANDCUSTOMERRANGE

Overview

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

CODE

=SI.EXPANDCUSTOMERRANGE(ConnectionName, Range, Status)

The SI. EXPANDCUSTOMERRANGE 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 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)

CODE

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

Description

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

Results

CODE

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

Description

Returns every Customer ID which does not start with 100.

Results

CODE

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

Description

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

Results

Assuming the following configuration within Sage Intacct:

CODE

=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