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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Receivables Aging Reconcile

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

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


    Thanks

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    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
    on at

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

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans