How do I correct a Customer statement error

(0) Share

Report

Posted on by Community Member

Last month my system crashed while I was applying a customers check. Only a partial is showing in the system and on the statement but the smart list balance for the customer is correct. The open items as shown under Sales/Trans by Customer is correct. The statement is NOT correct. How do I fix this?

I thought I entered the balance due the customer under Financial/Bank Transaction/Receipt but I cannot find it there. I was going to void the receipt and enter a payment for the $ as it would zero itself out but I cannot see it listed.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

Please try the following, before you do this please make a backup of the database.

1) Reconcile the sales documents and checkif that correct the statement (Utilities-Reconcile Receivables Amount)

2) Run the Maintenance->Check links-> Sales-> Receivable Open transactions files

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report

Hi Mguyder!

I agree with Babu however I would run the check links prior running the Reconcile. I have added the steps I send out when there is an issue such as this for the reconciling.

Microsoft Dynamics GP | Tools | Utilities | Sales | Reconcile

Mark the radio button for Outstanding Document Amounts

Unmark Reconcile leaving Report Marked ( This is to verify the correct amounts for documents prior to actually reconciling.)

Limit the Customer ID to the Customer which is having the issues

Click Process

Once you have confirmed that the correct amount has return, repeat the steps above but skipping the unmarking of Reconcile.

Please let us know if you have any additional questions!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I run "Reconcile" at the end of every month do that was alreay done.

I ran the Maintenance/Sales/Open Tran and got the following:

RM Apply Open File - PAYMENT42698: The transaction for this apply information was missing. The apply info

has been removed.

RM Key File - PAYMENT42698: The transaction for this key is missing. The key record has been removed.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

So is the statement correct now.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The statement was not correct .

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report

Hi Mguyder,

Is the payment that was removed from by the check links still showing up on Statement or is it missing from the Statement? Were you able to recreate the payment?

Please let me know!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

The checklinks was removed the missed apply information. Means both payment and invoice are moved to unapply status. You need to apply the document again.

Please check and apply this on Apply Sales Document window.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

I agree with Soma, you might have to book the receipt again and apply it for the invoices.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I ended up calling Microsoft. Becuz the payment had be reconciled I could not void anything out. MS could not figure out what was going on.

After 3 account reconciliations it cleared it self off the books.

TY

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

So, problem solved?

If yes, you can mark that your answer 'solved' the question. That way, a bunch of folks (like me) won't be reading this question hoping to solve it :)

Leslie

Was this reply helpful? Yes No