Description

The ACCOUNTTYPE function returns the type of a specified general ledger account.

Syntax

ACCOUNTTYPE(Connection, Account)

Parameters

The ACCOUNTTYPE function uses the following parameters (see our article using arrays or cell ranges as parameters):

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Account

Required

The general ledger account for which the Type is to be displayed.

Example

=ACCOUNTTYPE("Demo","10100")

Description: Returns the account type of general ledger account #10100 account.

Result: Asset

If a non-existent account is specified, the ACCOUNTTYPE function will display the message Account 'xxxxx' not found...

accounttype_notfound_1.png

or, if you have configured Velixo reports to return zero values under certain circumstances...

Options_return_zero.png

... your report will display Excel's #N/A error:

accounttype_notfound_2.png

Applies to

  • GL Module

Did this answer your question?