Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Receivables Aging Reconcile

Posted on by Microsoft Employee

Hi


Can someone please advise the difference between

Sales\Routines\Aging (Receivables Aging Process)

and

Tools\Utilities\Sales\Reconcile\Current Debtor Information

Both of them seem to re-calculate against the due date and the payment terms what aging period an invoice should sit under. Does one achieve something the other doesn't?

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Receivables Aging Reconcile

    Great thanks for looking into in such detail. I will only include the routine in month end maintenance as it is much quicker.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Receivables Aging Reconcile

    Hello Tania

    I have thoroughly checked the process of both; Aging Routine and Sales Reconcile Utility for the current customer information. In fact, I found no different in the result regardless of the technical methods used by each one of them to reach the exact same result.

    Both processes (which calculates in a different technical method) consider the following primary tables: RM20101 (RM Open Transactions) and RM00103 (Customer Master Summary). As for the RM20101, each of the open transactions is recalculated based on its due date primarily in order to calculate and update (if required) the aging bucket. Eventually, the balance for each aging period along with the customer balance are updated in the master table (RM00103)


    Therefore, following the tiny details of the process on the SQL profiler to check the logical and technical flow of both processes showed me no difference in the end result, while the methods of both are totally different.


    Please keep us posted in case of any further updates

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Receivables Aging Reconcile

    Just in addition to this, the routine takes significantly less time to run than the utility.


    Thanks

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans