Solved

Microsoft Dynamics GP--Receivables Issues

Posted on 2013-12-03
1
357 Views
Last Modified: 2013-12-07
Hello:

About six months ago, a client upgraded to GP 2010 service pack 3 and says that Life to Date amounts in the Payment Summary Inquiry window for Customers have been inaccurate ever since the upgrade was performed.

We ran reconcile, to no effect.  Also, the client says that she runs check links monthly.

In addition, the first record in the Customers lookup window is blank.  Usually, such a record is deleted by running check links on the Customer Master tables.  I tried that, but the blank record is still there.  Is getting rid of this blank record as simple as running a delete statement for it in SQL on the RM00101 table?

In any case, what can be done to combat both of these issues?

Thanks!

TBSupport
0
Comment
Question by:TBSupport
1 Comment
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 39695273
These are most likely two completely unrelated issues.

For the blank customer record - yes, delete it from RM00101 and then run check links. Of course a backup is recommended prior to any data manipulation. :-)

For the Life to Date amounts being inaccurate I think GP Support has a script to recalculate all of the customer summary totals, but you would need to ask them for it.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question