ACCOUNTCLASSLIST function
Created by Harry Lewis, Modified on Mon, 19 May at 3:29 AM by Velixo Team
Applies to
Velixo Classic
Velixo NX
Acumatica, MYOB Acumatica, Cegid XRP Flex
GL Module
Description
The ACCOUNTCLASSLIST function returns the list of GL account codes that are assigned to the specified account class.
TABLE OF CONTENTS
Syntax
ACCOUNTCLASSLIST(ConnectionName, 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 |
ConnectionName | 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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article