Issue with Sales Invoice/Payment

(0) Share

Report

Posted on by Community Member Microsoft Employee

We were entering a cash receipt in the system and applying it to an invoice when the system froze and we had to exit out. Now when we go in the invoice shows with the document amount as $2500.00 and remaining amount as $0. When I click on remaining amount to verify what paid the invoice it shows nothing. When I go to transaction by customer it shows 3 invoices of $2500.00 2 payments of $2500.00 but no balance due and it is not showing the 3rd payment anywhere. Any ideas where I can go from here?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Zohaib Asghar 250 on at

Like (0)

Report

RE: Issue with Sales Invoice/Payment

Dear Emily

You can try reconciliation of receivables amounts.

Take a backup before this process.

Microsoft Dynamics GP > Tools > Utilities > Sales > Reconcile

Select 'Outstanding document amounts' and select the customer.

Please share the results.
MattPaulen 6,910 on at

Like (0)

Report

RE: Issue with Sales Invoice/Payment

Are you familiar with Checklinks at all? You could try running that to see if it repairs the documents. It's always suggested to make a back up of your databases prior to running checklinks, though. It'd be the Receivables Open Transactions that you'd want to run checklinks for. If that doesn't fix it, most likely the documents will need to be repaired through SQL. Depending on your sql knowledge/access, you may need to reach out to your GP partner for that.