Dynamics Community Forum Thread Details

Customer Balance List Report & GL Do Not Tie to Customer Transaction Screen & Customer (AR) Aging

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

Any ideas?

Quick Links