BC.CREDITS
Overview
The BC.CREDITS function lets you retrieve the total credit amount of transactions affecting specified GL accounts between two dates.
Syntax
=BC.CREDITS(
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 reference to a cell in a valid Excel date format) |
| Required | The inclusive end date in YYYY-MM-DD format (or a reference to a cell in a valid Excel data format) |
| 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
=BC.CREDITS(
"BC",
,
"assets",
,
"2023-12-31",
"2023-12-31"
)
Description:
Returns the total of the credits applied to all accounts in the category Assets
during December 2023, within the connection named BC
.
