SI.EXPANDVENDORRANGE

Overview

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

CODE

=SI.EXPANDVENDORRANGE(
    ConnectionName, 
    Range, 
    Status
)

The SI. EXPANDVENDORRANGE 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 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 `""` or `blank` - include all statuses (available in version 2023. and higher)*

CODE

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

Description

Returns all Vendor IDs

Results

CODE

=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:

CODE

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

Description

Returns all active Vendor IDs within Sage Intacct.

Results

Inactive vendor 20001 is not included