TBSupport
asked on
Microsoft Dynamics GP--Receivables Issues
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.