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

acctclasslistex.png

Applies to

  • GL Module

Did this answer your question?