Description
The ACCOUNTTOTALDEBITS function calculates the total debits of one or more general ledger account(s) for a given period.
Syntax
ACCOUNTTOTALDEBITS(Connection, Ledger, AccountClass, Account,
Subaccount, Branch, From, To, IncludeUnposted)
Parameters
The ACCOUNTTOTALDEBITS function uses the following parameters (see our articles on Filtering Velixo Functions and using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | 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. |
From | Required | Beginning of the financial period, in MM-YYYY format or Cell reference to the beginning date |
To | Required | End of the financial period, in MM-YYYY format. or Cell reference to the ending date |
IncludeUnposted | Optional | 1 - Include posted transactions only (default) 2 - Include Unposted transactions only 3 - Include Posted and Unposted transactions* (note: Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted).
Excel for Windows allows the use of quotation marks around this parameter. Excel for Mac and Excel Online require that it be unquoted. |
Examples
Based on this data:
Example #1 (using Financial Period)
=ACCOUNTTOTALDEBITS("Demo", "ACTUAL", , "10200",, "PRODWHOLE", $F$1,
$F$1)
Description: Calculates the total debits posted in general ledger account #10200 of the PRODWHOLE branch during the period of 01-2019.
Result: 4,548,435
Example #2 (using cell references to dates)
=ACCOUNTTOTALDEBITS("Demo", "ACTUAL" , , $B7 , , , $C$4, $D$4)
Description: Calculates the total debits posted in general ledger account #10600 (as noted in cell B7) between January 1, 2019 and January 15, 2019 (as noted in cells C4 and D4).
Result: 3,325
Limitations to filtering by date instead of financial period:
|
Applies to
GL Module