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.

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.