Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Don McCready]

Gang,

I’m sure the answer to this already exists here but I couldn’t find it after an hour of searches and reading.

My AP Historical Aged Trial Balance is not aging some amounts correctly.  The attached doc shows the AP setup, the report definition, and a sample of the output.  The output indicates that an invoice due on 6/5/17 was over 91 days past due on 4/30/17.  It may be aged on the document date instead of the due date but that’s not what the setup calls for.

Note that the invoice above it for the same vendor is aged correctly.  The due date is 5/28/17 and it is in the Current bucket.

A clue: The invoice with the bad aging was originally entered with an incorrect due date of 1/1/17 which would been over 91 days past due.  That date was subsequently corrected to 6/5/17.  I wonder if the HATB somehow cannot reference the correction and can only “see” the original entry.

Thanks for any help!

——————————
Don McCready
Controller and IT Director
The Schaefer Group, Inc.
Beavercreek OH
——————————

[Kevin Powell, CPA, CGMA]

Don,

Couple of things.  Have you run maintenance on the module?  Are these items still open or in history?  Run the below to see what dates may be in the backend for the transaction (changing the DOCNUMBR for the document you have the issue with.)

/**show information from PM Keys**/
select VENDORID, DOCNUMBR, DUEDATE from PM00400 where DOCNUMBR=’XXXXXX’
/**Show information from PM Open**/
Select VENDORID, DocNUMBR,DOCAMNT, DOCDATE, DUEDATE from PM20000 where DOCNUMBR=’XXXXXX’
/**Show information from PM History**/
Select VENDORID, DocNUMBR,DOCAMNT, DOCDATE, DUEDATE from PM30200 where DOCNUMBR=’XXXXXX’

Thanks,

——————————
Kevin Powell
IMC Companies, LLC
——————————
——————————————-

[Victoria Yudin]

Hi Don,

Only the top section you have highlighted on Payables Management Setup window, the one called Aging Periods, is used for the HATB report. So the report is (correctly) showing aging by Document Date. Invoice Date is 1/1/2017, so it’s going to be in the 91 and Over bucket on 4/30.

The Apply By section in the middle of the window, where you have selected Due Date, is only used when you click the Auto Apply button when applying payments. So for example, you are entering a payment and there are 20 open invoices, you click Auto Apply, it will look at this setting to determine what order it should pick the open invoices in to apply the payment to – by Document Date or Due Date.

If you want your HATB report to use the Due Date for the aging calculations, you will need to change that setting in the Aging Periods section at the top of the window, where it’s currently set to Document Date. Please note that this will also change the calculations for any windows where GP shows you the aging buckets, for example the Vendor Credit Summary Inquiry. You may need to run Reconcile on the Payables transactions after changing this setting for all the data to be updated properly.

——————————
Victoria Yudin
Microsoft Dynamics GP MVP 2005-2017
Flexible Solutions, Inc.
http://www.GPReportsViewer.com
http://victoriayudin.com
——————————
——————————————-

[Don McCready]

Victoria,

Thanks for the definitive solution and detailed explanation!  Changing the setting to Due Date in the Aging Period section was the answer.

——————————
Don McCready
Controller and IT Director
The Schaefer Group, Inc.
Beavercreek OH
——————————
——————————————-