BC.ACCOUNTSUBCATEGORY

Overview

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

Syntax

=BC.ACCOUNTSUBCATEGORY(
    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.ACCOUNTSUBCATEGORY(
    "BC",
    "13200"
)

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

Excel worksheet showing BC.ACCOUNTSUBCATEGORY returning the account subcategory for account number 13200 in a Business Central connection