Problem: User entered an incorrect cleared amount when reconciling checks in AP. Now the reconciliation report is reporting that incorrect cleared amount, and a balance on the check.
Cause: Incorrect data entry.
REsolution: There is no way to fix or adjust the cleared amount in the system, but you can update the pmtamt and curypmtamt on the apdoc record to correct the report. Example: If the check cleared the bank for 10,000.00 but the user entered a cleared amount of 1,000.00 when reconciling the check, you could run an update like this in sql server. Where 001234 is the reference number of the check and CK is the document type of the check.
update apdoc set pmtamt = 10000.00, curypmtamt = 10000.00 where refnbr = '001234' and doctype = 'CK'