Aging of AR Invoices

(1) Share

Report

Posted on by rcr123

7,986

Good day,

Aging of invoices are done at the end of the month as part of the AR close. The report run is the Aged Trial Balance with options, this report when printed at the end of the month will say 'Aged as of' and have the month end date.

Is there any other option that will cause this aging date to change and subsequently affect the respective documents in the middle of the period?

One such report was done as at June and the same report if run today is saying 'Aged as of' 7/8/2022.

Regards

Rosemary

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Lisa at AonC.com 1,146 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What you may be running into is an aging done from Routines (that impacts customers with balances) and aging done from Utilities (as part of the Reconcile) that ages all the customers included in the customer range, even those without a balance.

Hopefully you have also discovered the use of Historical Aged Trial Balance when recreating the aging as of a prior date once newer transactions have been processed. :)

Was this reply helpful? Yes No
rcr123 7,986 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response, well this is new, I have used the Receivables Reconcile for outstanding amounts, but not the Reconcile option. I did not realize it would have done that, that is move the documents to other buckets.

The HATB is also used, but I'm not too clear on your statement though, I can print prior dates, but what of the newer transactions?

Regards

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 1,146 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The Reconcile Window defaults the Aging Date to the GP Current Date. The user can set it to a different date prior to reconciling.

The Aged Trial Balance - Options (ATB) is not date-sensitive. It is based on the current open data. The Historical Aged Trial Balance (HATB) recreates the data based on the date used when generating the report.

Was this reply helpful? Yes No
rcr123 7,986 on at

Like (0)

Report
Copy link

Link copied!

Okay, much clearer, our Financial YE is in September so I started some cleaning up. We have salesmen that use the TB during collections I understand their confusion now, the TB would have been as at June 30 and I did the Reconcile afterwards.

I can use the HATB as at June for them to make things simpler.

Thank you again, the community is really a helpful place.

Regards

Rosemary

Was this reply helpful? Yes No
RR-07061806-0 1,011 on at

Like (0)

Report
Copy link

Link copied!

Good day,

I have a question relating to the above scenario, when doing a Reconcile can I change the default date which is the current date to the previous month end date? And what kind of consequences will there be if any.

Regards

Rosemary

Was this reply helpful? Yes No