Description

The ACCOUNTCLASSLIST function returns the list of GL account codes that match the specified account class(es).

Syntax

ACCOUNTCLASSLIST(Connection, AccountClass)

Parameters

This function uses the following parameters (see our articles on including multiple parameter values 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?