SUBACCOUNTNAME
Overview
The SUBACCOUNTNAME function returns the name of the specified GL subaccount.
Syntax
CODE
=SUBACCOUNTNAME(Connection, Account)Arguments
The SUBACCOUNTNAME function uses the following arguments (see our article on using arrays or cell ranges as parameters):
Argument | Required/Optional | Description |
| Required | The name of the connection, as specified in the Connection Manager |
| Required | The general ledger subaccount for which the name is to be returned |
Example
CODE
=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...
