ACCOUNTCLASSLIST function

Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud

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(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

 

acctclasslistex.png


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article