BC.EXPANDACCOUNTSUBCATEGORYRANGE

Overview

The BC.EXPANDACCOUNTSUBCATEGORYRANGE function returns general ledger account subcategory names matching the search criteria.

CODE

=BC.EXPANDACCOUNTSUBCATEGORYRANGE(
    ConnectionName,
    AccountSubcategory,
    AccountCategory
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`AccountSubcategory`	Optional	Subcategory name filter. Supports Velixo range expressions for specifying multiple values.
`AccountCategory`	Optional	One or more account category names, visible in the Business Central Chart of Accounts. The following values are accepted: `Assets`, `Liabilities`, `Equity`, `Income`, `Cost of Goods Sold`, `Expense` Supports Velixo range expressions for specifying multiple values.

CODE

=BC.EXPANDACCOUNTSUBCATEGORYRANGE("BC",,"Assets")

Description: Returns all subcategory names in the category Assets for the connection BC.