We have a cash application that has somehow updated on the customer balance list report and GL vouchers under the correct dollar amount but under the customer transaction screen and the customer aging report it shows a different (wrong) amount. Has anyone ever had the software update these with two different amounts? How can we correct the posting?
We tried applying the cash amount needed to correct the transaction screen & customer aging but that just moves the wrong amount over to the customer balance list & GL (while fixing the transaction screen and aging). I don't know of a way to change one without changing the other. We reversed off that attempt.
Next we unsettled the cash application and tried to cancel it but there's a stop error for being /out of balance/ even though all the dollar amounts listed in the error are balanced (I'm guessing because canceling the posting will update these two areas by different amounts which the system should not allow).
Note: the GL associated with AR does not allow manual postings, and we verified all posting to the GL have been systematic entries
Summary: Cash application posted with differing amounts (shouldn't be possible). Unable to cancel the cash application. Unsure how to correct. Correct Amounts = Customer Balance List Report & GL Balance Wrong Amounts = Customer Transaction Screen & Customer Aging Report
Additional information - the cash record (which is unsettled at this point) somehow still shows a settlement amount of the dollar amount we are off by. If you trace the history on both sides (the cash application and the invoice it was applied to) there is an extra line showing on the cash application that has no offset on the invoice it is labeled as being settled against.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
