Unapplied Amount incorrect

[hungtran817]

On the Apply Sales Document window, the Unapplied Amount doesn't add up to the amount that we applied.
Example, on the print out shows that we applied $1000.00 to several invoices from a payment of $1500.00. Instead of showing $500 in the unapplied amount, it's showing $750.
What happened?

 

[jazgeek]

are you sure all payments have been posted?

-----------
and they wonder why they call it Great Pains!

jaz

 

[VictoriaYudin]

Usually this happens if you crash while entering or posting the cash receipt.... have you tried reconcile or check links? Sometimes these will fix it, sometimes they won't. If not, you will need to fix it in the tables.

 

[njp123]

I have seen this before. Sounds like you have some corrupt records. You can fix with SQL queries. Just be careful(make backup)
info@logicalsolutionsllc.com

 

[hungtran817]

Which tables and fields would be involved?

 

[stef315]

Always try reconcile and check links before messing around in the tables.

Can you void the payment and re-enter if those don't work?