Skip to main content
Skip table of contents

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.

image-20250926-115235.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.