Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AR Summary information...
Microsoft Dynamics GP (Archived)

AR Summary information is wrong after upgrading to 2016R2

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We upgraded in August from 2013R2 to 2016R2. Our controller closed the AR module last night and now we have discovered that our customer summary balances are way off. For example, I have one customer that has only ever paid 1 invoice in the amount of $4545... This invoice was paid with a credit memo. But in the summary window for this customer, it is showing 43,725 sales documents life to date and a total of $98,885,352 sales invoices life to date. I can only find this incorrect information in the RM00103 table. 

Has anyone ever seen this before and if so, how do I get this resolved? 

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: AR Summary information is wrong after upgrading to 2016R2

    Since the RM00103 is a summary table, have you tried to run the reconcile utility? This utility will recalculate the summary based on the detail.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Summary information is wrong after upgrading to 2016R2

    I have performed this for the customer in question going back to 1996 and it did not correct my issue.

  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: AR Summary information is wrong after upgrading to 2016R2

    Hi Asimoneaux1

    For starters I would run the reconcile process.

    Microsoft Dynamics GP > tools > utilities > sales > reconcile

    Run it on the Current Customer information, outstanding document amounts, fiscal year (start with the oldest fiscal year and calendar year (starting with first calendar year)

    Try this first and then let us know if this does not solve the problem

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans