BC.ACCOUNTNAME

Overview

The BC.ACCOUNTNAME function returns the account name corresponding to a given account code, as visible in the Business Central Chart of Accounts.

CODE

=BC.ACCOUNTNAME(
    ConnectionName,
    Account
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Account`	Required	The code of the general ledger account, a spill range, or a cell range containing account codes. For example, `10100`, `A1:A10` or `A1#`

CODE

=BC.ACCOUNTNAME(
    "BC",
    "12100"
)

Description: Returns the account name for the account number “12100”.