Client entered a duplicate check, and later reversed the first check. After posting, reversed checks were printed and purged.

She also wanted to reverse the second check.
When second (duplicate) check was reversed, a data integrity error was created because the reversal was applied to the first check, not the second.

Rebuild created an entry to balance it so now the Vendor account has
MC outstanding amt = -300, original amt = -300
RC outstanding amt = 300 , original amt = 300
Data Integrity reports no errors

The Open Payables report shows the two open transactions:
MC -300 and RC 300

However the Overdue payables report shows only the RC 300.
The Vendor before this one on the report has one invoice duplicated and on the same line the -300.

The totals on the reports match, so the error is in the details and their display and not in the calculated totals.

Why did re-build create a transaction that is impossible to apply or resolve, and how do we fix this?

Hi, Kate,

AP doesn't prevent users from entering duplicate checks. It will only warn them that they are about to do so.

It sounds like this site is using an older version of AP and that rebuild was unable to correct the situation.

They will have to either ignore the entries, revert to a prior backup or have a database repair done.

They are using the latest version, and service pack, of AP.

The first reversal was done in June when they first started, on version 8.0A.
The second was done this year after the upgrade to 8.1.

The entries cannot be ignored, since the Overdue Payables report is wrong for this vendor and for one other unrelated vendor. This appears to be a problem in the program. The Vendor transactions are correct in the Vendor accounts, except that one vendor shows 2 open transactions that cannot be applied, one an MC and the other an RC. Again, this appears to be a program problem.

Hi, Kate,

We'd need to see data to look at this more deeply. Are you able to send it to us? Of course, we would also need you to point us in the right direction to the vendor, etc. Can you email that information to us? Depending on the size of the data, it may require an upload and we'd need to know the name of the file. Do you have a backup of the data containing the duplicates prior to their being reversed also?