Description
The ACCOUNTCLASSLIST function returns the list of GL account codes that are assigned to the specified account class.
Syntax
ACCOUNTCLASSLIST(Connection, AccountClass)
Parameters
This function uses the following parameters (see our articles on Filtering Velixo Functions and using Excel arrays or cell ranges are parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
AccountClass | Required | The account class(es) for which the component accounts are to be displayed. |
Example
=ACCOUNTCLASSLIST("Demo","Sales")Description: Returns the list of accounts with an Account Class of Sales
Result: 40000;40010;40020;41000
Applies to
GL Module