BC.ACCOUNTCATEGORY

Overview

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

Syntax

=BC.ACCOUNTCATEGORY(
    ConnectionName,
    Account
)

Arguments

Argument

Required/Optional

Description

ConnectionName

Optional

Provide one of the following values:

Connection name as defined in Connection Manager.
Velixo range expression defining a set of connection names.
An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array.

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#

Example

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

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

Excel worksheet showing BC.ACCOUNTCATEGORY returning the account category for account number 12100 in a Business Central connection