SI.EXPANDVENDORRANGE

Overview

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

=SI.EXPANDVENDORRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDVENDORRANGE 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 Vendor IDs to be displayed. See Filtering Velixo Functions.
`Status`	Optional	Determines whether to limit the results based on the contents of the Vendor's Status field value. Options: `"A"` - active `"N"` - active, non-posting `"I"` - inactive blank (empty value) - include all statuses (available in version 2023. and higher)

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

Description

Returns all Vendor IDs

Results

=SI.EXPANDVENDORRANGE(
    "Sage",
    "*;-20000:20100"
)

Description

Returns all Vendor IDs expect those between 20000 and 20100 (inclusive).

Results

Assuming the following configuration within Sage Intacct:

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

Description

Returns all active Vendor IDs within Sage Intacct.

Results

Inactive vendor 20001 is not included