BC.BUDGETTURNOVER

Overview

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

Syntax

CODE

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

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`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.

Example

CODE

=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.