SI.EXPANDACCOUNTGROUPRANGE

Overview

The SI.EXPANDACCOUNTGROUPRANGE function returns the list of Name field values from the Account Groups form in Sage Intacct.

CODE

=SI.EXPANDACCOUNTGROUPRANGE(ConnectionName, AccountGroup)

The SI. EXPANDACCOUNTGROUPRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`AccountGroup`	Optional	The range of account groups to include in the results. Supports Velixo filtering techniques. For account groups to be searchable using Velixo filtering techniques, their names must not contain special characters, e.g., @, ! or :.
`AccountGroupType`	Optional	Optionally filters the returned account groups by type. The following values are supported: `A` - accounts `C` - category `G` - groups `S` - statistical accounts `T` - statistical category `X` - computation (default: ACGSTX to return all group types)

Assuming the following configuration within Sage Intacct:

CODE

=SI.EXPANDACCOUNTGROUPRANGE("Sage")

Description
Returns the name of all account groups defined in Sage Intacct:

Result