OK now that I have seen the data, I can tell you quite a bit.

(For those who haven't seen the data, the vendor's balance is zero, but there are offsetting transactions with current balances. Unfortunately, one of the outstanding transactions is a check.)

Your data is corrupted. It is not possible for you to fix a transaction that is a payment or reversed check with a current balance. Data Integrity Check doesn't detect it, and you can't delete the vendor (as you have found out).

I ended up (just for the heck of it) running your data through my copy of FixIt Plus, which is an ACCPAC Plus third party program. It is not recommended to do that, especially on Adagio data, but it was worth a try. Amazingly, it removed the offending check transaction, and found a few other errors that have accumulated over the years.

Take a look at the data I sent you back and test it carefully. There's a good chance that you are OK now.

You may ask how a check transaction could ever have a balance. The short answer is - it can't. However, I have seen it happen when a check that was issued in Adagio AP was reversed using ACCPAC Plus AP. Adagio Data Integrity Check will detect and clean up this problem, but if you happen to run FixIt Plus on the data instead, you are dead. That's why I am so amazed that it worked in this instance.

IN DIV-090103 08/01/03 09/01/03 3,500.00 3,500.00

PA 17811 08/26/03 17811 -3,500.00 -3,500.00