Description

The SUBACCOUNTNAME function returns the name of the specified GL subaccount.

Syntax

SUBACCOUNTNAME(Connection, Account)

Parameters

The SUBACCOUNTNAME function uses the following parameters (see our articl on using arrays or cell ranges as parameters):

Parameter

Required/Optional

Description

Connection

Required

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

Subaccount

Required

The general ledger subaccount for which the name is to be returned

Example

 =SUBACCOUNTNAME("Demo", "000CON")

Description: Returns the name of subaccount #000CON.

Result: Consulting

subacct.png

If a non-existent subaccount is specified, the SUBACCOUNTNAME function will display the message Subaccount 'xxxxx' not found...

subaccountname_notfound_1.png

Applies to

  • GL Module

Did this answer your question?