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

CODE

=BC.ACCOUNTSUBCATEGORY(
    ConnectionName,
    Account
)

Arguments

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#`

Example

CODE

=BC.ACCOUNTSUBCATEGORY(
    "BC",
    "13200"
)

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