BC.BUDGETTURNOVER

Overview

The BC.BUDGETTURNOVER function lets you retrieve the turnover for a specified GL budget between two dates.

Syntax

=BC.BUDGETTURNOVER(
    ConnectionName, 
    Account, 
    AccountCategory, 
    AccountSubcategory,
    Budget,
    FromDate, 
    ToDate, 
    Dimensions,
    UseReportingCurrency
)

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 if `AccountCategory` or `AccountSubcategory` is specified	The code of the general ledger account, a spill range, or a cell range containing account codes. For example, `10100`, `A1:A10` or `A1#`
`AccountCategory`	Optional if `Account` or `AccountSubcategory` is specified	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`
`AccountSubcategory`	Optional if `Account` or `AccountCategory` is specified	One or more account subcategory names.
`Budget`	Required	GL budget name or a range containing multiple budget names.
`FromDate`	Required	The inclusive start date in YYYY-MM-DD format (or a reference to a cell in a valid Excel date format)
`ToDate`	Required	The inclusive end date in YYYY-MM-DD format (or a reference to a cell in a valid Excel data format)
`Dimensions`	Optional	A two-column Excel range where the first column contains the name of a dimension and the second column contains a semicolon-separated list of values for that dimension You can specify dimension values using ranges, wildcards, and other techniques. See the Using Dimensions article for more details.
`UseReportingCurrency`	Optional	When a reporting currency is configured for your organization, set this argument to `TRUE` to return the results using the configured currency. Accepted values: `TRUE` or `FALSE` Default value: `FALSE`

Example

=BC.BUDGETTURNOVER(
    "BC",
    "41450",
    ,
    ,
    "GLB",
    "2025-02-01",
    "2025-02-28"
)

Description:

Returns the turnover for the budget GLB in the account 41450 in February 2025, within the connection named BC.

Excel worksheet showing BC.BUDGETTURNOVER returning the turnover for the GLB budget in account 41450 for February 2025 in Business Central