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 / Microsoft Dynamics GP (Archived) / RM Customer Yearly Sum...
Microsoft Dynamics GP (Archived)

RM Customer Yearly Summary does not add up to actual Activity

(0) ShareShare
ReportReport
Posted on by Community Member

We ran a Smart List and added up the invoices, payments, credit memos, etc for the last 4 years the company has been on the system. The totals we get are correct 4 2011 and 2012, however, the invoice amounts for 2010 and 2013 do not tie. We ran a reconciliation on calendar years, fiscal years, outstanding document amounts and current customer amount but that did not change anything. What could cause the Summary inquiry to not add up to the detail activity and how do we fix it?

Thanks!

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    Thanks to all who replied. They appear to have had an issue with some information they had imported in over a year ago. They just now reconciled. We have cleaned up the offending info and were able to reconcile. Not sure why it was so weird but...

    Thanks!

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    Have you excluded voided transactions from your queries and taken into consideration things that may have been entered through receivables rather than SOP?

    Kind regards,

    Leslie

  • GP1Antonio Profile Picture
    GP1Antonio 20 on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    The Life-to-Date numbers from the Receivables Summary Inquiry screen should match by customer against the SmartList totals. If they don't match, then pull the records from the RM20101/RM30101 tables and compare the totals from RM20101/RM30101 to the Smartlist totals (this requires either using MS Access or SQL Server Management Studio or similar tool to run queries directly against the tables).  

    If those totals match then the problem is likely a bug in the report you are using to get your summary totals.

    If they are different, then either the Smartlist isn't returning the data correctly, or else there is corrupt data in the SQL tables and you may need to open an MS support ticket.

    Antonio Suescum

    www.greydogit.com

  • Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    I am using the Receivables transactions smart list and have pulled all transactions for the customer. I have sorted by transaction type and have gotten he totals for each year by type.

    The LTD does not match the totals, nor do 2 of the years.

    They have never closed the AR module, would that cause the totals to not change on the reconcile?

    Thanks!

  • GP1Antonio Profile Picture
    GP1Antonio 20 on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    Antonio Suescum

    www.greydogit.com

  • GP1Antonio Profile Picture
    GP1Antonio 20 on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    Which reports and/or Smart List queries are you using?  Are they only sourced from Receivables and Payables or are you comparing with the GL and any other modules (PA, etc.)?

    It helps to know if the problem is within a module or caused by the way the transactions are posted to the GL.

  • Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    We reconciled everything starting with the oldest year and working forward. NO changes.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    Sales >> Utilities >> Reconcile

    Use the Reconcile Receivables Amounts window to reconcile receivables amounts. Information in multicurrency tables also is reconciled. You should reconcile amounts if a system problem such as a power fluctuation occurs, and you need to be sure your data is accurate. You also might use the reconcile process if you discover inconsistencies in reports. Back up your company's data before reconciling so you can restore this information, if necessary.

  • Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    They have not closed but I was confused because the amount in total is not correct. I would expect timing differences I am just confused as to how $2,800 is not accounted for.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: RM Customer Yearly Summary does not add up to actual Activity

    If you do not run your year end close for Ap and AR on Jan 1st each year, you need to get some sql scripts from MBS support to correct the YTD amounts for each fiscal year.

    They fix Payables an Receivables Mgmt.

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,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans