ACCOUNTTOTALCREDITS function
Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud
Applies to
Velixo Classic
Velixo NX
Acumatica, MYOB Acumatica, Cegid XRP Flex
GL Module
Description
The ACCOUNTTOTALCREDITS function calculates the total credits of one or more general ledger accounts over a given period.
TABLE OF CONTENTS
Syntax
ACCOUNTTOTALCREDITS(Connection, Ledger, AccountClass, Account, Subaccount, Branch, FromPeriodOrDate, ToPeriodOrDate, IncludeUnposted, UseMasterFinancialCalendar)
Parameters
The ACCOUNTTOTALCREDITS 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. |
FromPeriodOrDate | Required | Beginning of the financial period, in MM-YYYY format or the beginning date in a valid Excel date format |
ToPeriodOrDate | Required | End of the financial period, in MM-YYYY format. or 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 (notes:
Excel for Windows allows the use of quotation marks around this parameter. Excel for Mac and Excel Online require that it be unquoted. |
Use Master Financial Calendar | 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:
|
Examples
Based on this data:
Example 1
=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
=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
|
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article