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

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

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Reconcile typically fixes this issue.  You need to look at the fiscal period/year dates to make sure what the system will use matches what you have in the SmartList.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

    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

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

    Thanks!

  • GP1Antonio Profile Picture
    GP1Antonio 20 on at

    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.

  • GP1Antonio Profile Picture
    GP1Antonio 20 on at

    Antonio Suescum

    www.greydogit.com

  • Community Member Profile Picture
    Community Member on at

    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

    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

  • L Vail Profile Picture
    L Vail 65,271 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans