ACCOUNTTOTALCREDITS

Overview

The ACCOUNTTOTALCREDITS function calculates the total credits of one or more general ledger accounts over a given period.

Syntax

CODE

=ACCOUNTTOTALCREDITS(ConnectionName, Ledger, AccountClass, Account, Subaccount,  Branch, FromPeriodOrDate, ToPeriodOrDate, IncludeUnposted, UseMasterFinancialCalendar)

Arguments

The ACCOUNTTOTALCREDITS function uses the following arguments (see our articles on Filtering Velixo Functions and using arrays or cell ranges as arguments):

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Ledger`	Required	Ledger to use in the calculation.
`AccountClass`	Optional, though required if `Account` is empty	The account class to use for the calculation.
`Account`	Optional, though required if `AccountClass` is empty	The general ledger account(s) to use for the calculation.
`Subaccount`	Optional	The general ledger subaccounts(s) to include.
`Branch`	Optional	The branch(es) to include.
`FromPeriodOrDate`	Required	The beginning financial period, in MM-YYYY format or a reference to a cell containing the beginning date in a valid Excel date format
`ToPeriodOrDate`	Required	The ending financial period, in MM-YYYY format. or a reference to a cell containing the ending date in a valid Excel date format
`IncludeUnposted`	Optional	1 - Include posted transactions only (default) 2 - Include Unposted transactions only 3 - Include Posted and Unposted transactions Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted If a document is still in the AR module (e.g., Invoice), the corresponding GL batch has not yet been created, thus the balance for that document will not be reflected. Excel for Windows allows the use of quotation marks around this argument. Excel for Mac and Excel Online require that it be unquoted.
`UseMasterFinancialCalendar`	Optional	Use Acumatica's Master Financial Calendar instead of the financial calendar defined within the specific tenant associated with the connection being accessed (this can be useful for consolidation reports). Possible values: `TRUE` `FALSE` (default)

Examples

Based on this data:

Example 1

CODE

=ACCOUNTTOTALCREDITS("Demo", "ACTUAL", , "10200", , "01-2019", "01-2019")

Description: Calculates the total posted credits of General Ledger account #10200 (as noted in cell B6) during the first financial period of the year 2019 (as noted in cell G1).

Result: (3,431,030)

Example 2

CODE

=ACCOUNTTOTALCREDITS("Demo", "ACTUAL", , "11000", , $C$4, $D$4,3)

Description: Calculates the combined total of the posted and unposted credits of General Ledger account #11000 (as noted in cell B10) between January 1, 2019 (as noted in cell C4) and January 15, 2019 (as noted in cell D4).

Result: (1,248,715)

Limitations to filtering by date instead of financial period

This feature cannot be used with the Net Income account
Drilldown will show transactions for the entire financial period (you will then need to manually filter on the date column)
Balances are calculated based on the total from the nearest financial period, and then adjusted based on the filtered transaction date
Balances will not reflect transactions within the specified date range but which have been posted to a different financial period.