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
  • RR-07061806-0 Profile Picture
    RR-07061806-0 81 on at
    Aging of AR Invoices
    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
  • rcr123 Profile Picture
    rcr123 7,986 on at
    RE: Aging of AR Invoices

    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

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 604 on at
    RE: Aging of AR Invoices

    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
    RE: Aging of AR Invoices

    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 604 on at
    RE: Aging of AR Invoices

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans