BC.TURNOVER
Overview
The BC.TURNOVER function returns the balance turnover of one or more GL accounts between two dates.
This function requires the AL Language extension for Microsoft Dynamics 365 Business Central
Syntax
=BC.TURNOVER(
ConnectionName,
Account,
AccountCategory,
AccountSubCategory,
FromDate,
ToDate,
Dimensions
)
Arguments
Argument | Required/Optional | Description |
| Required | The name of the connection, as specified in the Connection Manager |
| Optional if | The code of the general ledger account, a spill range, or a cell range containing account codes. For example, |
| Optional if | One or more account category names, visible in the Business Central Chart of Accounts. The following values are accepted: |
| Optional if | One or more account subcategory names |
| Required | The inclusive start date in YYYY-MM-DD format or a cell reference to a date |
| Required | The inclusive end date in YYYY-MM-DD format or a cell reference to a date |
| 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 The dimension values can be specified using ranges, wildcards, and other techniques. |
Examples
Turnover for a single account
=BC.TURNOVER(
"BC",
"11110",
,
,
,
,
"2024-1-1",
"2024-3-31"
)
Description: Returns the turnover for the account “11110” in Q1 2024.
Result:

Turnover for a range of accounts
=BC.TURNOVER(
"BC",
D1:D10,
,
,
,
,
"2024-1-1",
"2024-3-31"
)
Description: Returns the turnover for the account numbers in cells in the range from D1 to D10 in Q1 2024.
Result:

Turnover for a accounts in a spill range
=BC.TURNOVER(
"BC",
D1#,
,
,
"2024-1-1",
"2024-3-31"
)
Description: Returns the turnover for accounts listed in the spill range beginning with cell D1 in Q1 2024.
Result:
