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