SI.EXPANDACCOUNTGROUPRANGE
Applies to:
Velixo NX
Sage Intacct
The SI.EXPANDACCOUNTGROUPRANGE function returns the list of Name field values from the Account Groups form in Sage Intacct.
Syntax
SI.EXPANDACCOUNTGROUPRANGE(ConnectionName, AccountGroup)
The SI. EXPANDACCOUNTGROUPRANGE function uses the following parameters:
Parameter | 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. Note: 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) |
Example
Assuming the following configuration within Sage Intacct:
=SI.EXPANDACCOUNTGROUPRANGE("Sage")
Description
Returns the name of all account groups defined in Sage Intacct:
Result
