BC.DEBITS

Overview

The BC.DEBITS function lets you retrieve the total debit amount of transactions affecting specified GL accounts between two dates.

CODE

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

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

CODE

=BC.DEBITS(
    "BC",
    ,
    "expense",
    ,
    "2023-12-31",
    "2023-12-31"
)

Description:

Returns the total of the debits applied to all accounts in the category Expense during December 2023, within the connection named BC.