Applied Amount is greater than document amount

[barbola]

We're on GP7.5 on SQL2000. We use Customer/Vendor consolidations for one customer. It was working fine but one invoice for $6000 shows an amount of $84,000 applied. Then the next time I consolidated, a bunch of Debit Notes and Credit Notes showed up. Now it is all a big mess and we should have had a credit of $110,000 for this customer, but ended up paying them $200,000.

I ran a reconcile on the Recvbles outstanding documents, and it came up with a report showing one invoice, one debit note, and three credit notes and each have the message "Aplied amount is greater than document amount". I also ran checklinks on the Sales tables and no error messages come up.

I think I recall my computer freezing up a while back, which is where teh 84,000 came from. I remember seeing an article where I had to create a dummy invoice, apply it, and then remove from history. Not sure I can still do this because I have since run Pd Trx Removal thinking that might fix it.

Any ideas?!

Thanks!
Barb E.

 

[Dukester0122]

Running Paid Trx Removal won't fix it because all paid transactions and checks will just be move from Open to History and the remaining balance which the message you were getting suggest there is would leave it to Open.

I don't know if this will work but here's what I did when we had a credit memo-$5000 applied to an invoice-$4000 then the Paid Sales Transaction Removal was ran against Paid Transaction and Checks. Since there was still $1000 left on the credit memo and later discovered it was applied to the wrong invoice. I voided the credit memo which moved the invoice back to open then ran Paid Trx Removal to move the credit memo to history then Utilities>Remove Trx History on the credit memo.

Hope this helps.

 

[barbola]

I ran a reconcile and it fixed the sales/receivables side. Now, there is a huge 200,000 credit on Payables that I need to get rid of!

I reconciled payables, but that didn't fix it. It just gets worse and worse.

Thanks!
Barb E.