In Check Reconciliation, we reversed a check. The check was for $23,839.39. The check went back on the vendor account with $0 in current and $23,839.39 in the original amount. The check was for 5 invoices and only 1 of the 5 was still in current, so $12,165.01 went to the 1 invoice in current leaving a remaining balance of $11,674.38. The $11,674.38 was suppose to go back to current on the other 4 invoices, but it didn't, I assume because they are in history.

$23,839.39 has already been paid out of our bank, so I need to post the check again for that same amount to balance. But since there is only $12,165.01 in current, we don't know how to post the check for the full amount again. How can we resolve this?

Disregard. Apparently we have data integrity errors.

Susan:

You may have DIC errors due to the reversal of a cheque where some invoices where still current and others where in history.

If you get a chance you might want to set up a copy of your database, make sure its free of errors, and try reversing a cheque where the same condition exists. Let us know how you make out.

DataCare did not fix the problem. :-(

It seems like it did something to the history records but the problem still remains in the current records.

Adagio Payables 9.2A (160524): Application Integrity

Vendor PU7124 history transaction CN 6011791953 computed balance -174.72 does not match stored balance 0.00
Vendor PU7124 history transaction CN 6011792145 computed balance -30.82 does not match stored balance 0.00
Vendor PU7124 history transaction DN 17-804-2 computed balance 6,972.13 does not match stored balance 0.00
Vendor PU7124 history transaction IN 432430552 computed balance 4,907.79 does not match stored balance 0.00
Checking History Transactions... ... 4 error(s) found

Summary

Application Integrity ... 4 error(s) found ..................................... FAILED

Data Repair Phase

Vendor PU7124 history transaction CN 6011791953 matching record added
Vendor PU7124 history transaction CN 6011792145 matching record added
Vendor PU7124 history transaction DN 17-804-2 matching record added
Vendor PU7124 history transaction IN 432430552 matching record added

Fixed 4 of 4 application integrity errors.

Susan:

Unfortunately I don't think this is a problem we are going to be able to resolve in this forum.

If you cannot get to the point where a DIC and Rebuild fixes your data (sometimes you have to run the process several times to get through all of the issues) then you either need to restore your database from a backup that doesn't have this problem or get your database repaired.

If the problem is repeatable then it can be submit to the developer to resolve the cause.

Both are best dealt with by your Adagio dealer.