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
If a non-existent subaccount is specified, the SUBACCOUNTNAME function will display the message Subaccount 'xxxxx' not found...  |
Applies to
GL Module