web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Aging of AR Invoices
Finance | Project Operations, Human Resources, ...
Answered

Aging of AR Invoices

(1) ShareShare
ReportReport
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)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 933 Super User 2025 Season 2 on at

    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.  :)

  • rcr123 Profile Picture
    rcr123 7,986 on at

    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

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 933 Super User 2025 Season 2 on at

    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.

  • rcr123 Profile Picture
    rcr123 7,986 on at

    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

  • RR-07061806-0 Profile Picture
    RR-07061806-0 627 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans