ACCOUNTNAME function
Created by Harry Lewis, Modified on Thu, 05 Oct 2023 at 05:49 PM by Gabriel Michaud
Applies to
Velixo Classic
Velixo NX
Acumatica, MYOB Advanced, Cegid XRP Flex
GL Module
Description
The ACCOUNTNAME function returns the name of one or more specified GL accounts.
TABLE OF CONTENTS
Syntax
ACCOUNTNAME(Connection, Account)
Parameters
The ACCOUNTNAME function uses the following parameters (see our articles 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 |
Account | Required | The general ledger account (or Excel array containing multiple accounts) to use for the calculation. |
Examples
Example 1
Referencing a single account
=ACCOUNTNAME("Demo", "10100")Description: Returns the name of general ledger account #10100.
Result: Petty Cash
Example 2
Referencing a list of accounts
Description: Returns the names of general ledger accounts included in a list in cell C2
Example 3
Referencing an array of accounts
Description: Returns the names of general ledger accounts displayed by an array starting in column C2
If a non-existent account code is specified, the ACCOUNTNAME function will display the message Account 'xxxxx' not found...  or, if you have configured Velixo reports to return zero values under certain circumstances...  ... your report will display Excel's #N/A error:  |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article