ACCOUNTTOTALDEBITS function

Created by Harry Lewis, Modified on Wed, 16 Oct at 4:40 PM by Harry Lewis

Applies to

  • Velixo Classic

  • Velixo NX

  • Acumatica, MYOB Acumatica, Cegid XRP Flex

  • GL Module

  

Description


The ACCOUNTTOTALDEBITS function calculates the total debits of one or more general ledger account(s) for a given period.


 

TABLE OF CONTENTS


Syntax

ACCOUNTTOTALDEBITS(Connection, Ledger, AccountClass, Account, Subaccount, Branch, FromPeriodOrDate, ToPeriodOrDate, IncludeUnposted, UseMasterFinancialCalendar)

 

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.

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

To

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

(notes: 

  • 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 parameter. Excel for Mac and Excel Online require that it be unquoted.

Use Master Financial CalendarOptional

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:

 

sampledata.png

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

 

debits_period.png

 

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

 

debits_date.png

 

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article