Skip to main content

What is the difference between age by document date and age by due date?

Due Date
The invoice is categorized by the number of days past the due date. If the payment terms are 60 days, then the date range in the most left column should only be the first 60 days. More than 60 days will be sitting under second column onwards, which shows they are now overdue for payment.

Invoice Date 
the invoice is categorized by the number of days since the invoice was posted

 To illustrate the difference between age by "Due Date" and "Document Date", I have printed out AP Aging Report as showing below.There are two invoice posted into different period with 60 Days payment terms.

a. Aging is printed as at May-2018


 Due Date
   -   Both invoice sitting under "Current" period as both invoice has not pass the 60 Days period when printing in May-2018.

Document Date
   -   Invoice from April will be moving to 31-60 Days; whereas invoice from May will still sitting in Current Period because it is posted in the same month as the aging date printed.


b. Aging is printed as at July-2018


 Due Date
   -   Both invoice are moving to respective aging bucket after payment terms has past due.


Document Date
   -   Both invoice move to the respective aging bucket based on the invoice date posted.
Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sal...
Post a Comment
Read more

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...
1 comment
Read more

Trial Balance Report in Microsoft Dynamics GP

Want a Trial Balance (TB) report from GP where the balances of all ledgers are summaries into debit and credit column totals that are equal? You can get it in GP easily. Path: Reports > Financial > Trial Balance 1.   Select “Summary” from Reports options. 2.   To create new report, click [New]. Or t o print existing report option, just select the report which available in the Options, then click [Modify]. 3.   Type a name for the report option that you want to use in [Option:]. 4.   In the Include section, select the "Posting Accounts" check box. 5.   Select the target fiscal year to generate in Year section. Please take note that if you are printing historical year, you need to select "History". 6.   Select the settings and restrictions that you want to use with the new report option. In the sample below, the TB that going to generate is March in 2017. You can also filter a group of the account code that need to generat...
Post a Comment
Read more