BC.EXPANDACCOUNTRANGE

Overview

The BC.EXPANDACCOUNTRANGE function returns all general ledger account codes matching search criteria.

Syntax

=BC.EXPANDACCOUNTRANGE(
    ConnectionName,
    Account,
    AccountCategory,
    AccountSubcategory,
    AccountType,
    IncludeBlocked
)

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. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`Account`	Optional	The code of the general ledger account, a spill range, or a cell range containing account codes. For example, `10100`, `A1:A10`, or `A1#` Supports Velixo range expressions for specifying 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 values.
`AccountSubcategory`	Optional	One or more account subcategory names. Use the BC.EXPANDACCOUNTSUBCATEGORYRANGE function to retrieve available values. Supports Velixo range expressions for specifying values.
`AccountType`	Optional	A string of characters (case-insensitive) corresponding to account types for which results will be returned. Available values: P - posting accounts H - heading accounts T - totaling accounts defined via account range B - begin-total accounts E - end-total accounts `PHTBE` is the default value (all types)
`IncludeBlocked`	Optional	`TRUE` (default) or `FALSE` To exclude blocked accounts from your result, set this argument `FALSE`.