I have had this problem in my A/P for sometime now. Please see attached file for a copy of my A/P report.

As you can see I have two entries that should off-set each other, but don't. Obviously, the problem is with the Cheque Reconciliation. I don't know how I can have a negative and a positive RC. I honestly don't know how I managed this. Is there anyway to get rid of these? I can't remove the vendor because I have history. I've done a yearend to purge history, but it's still there even though it's a 2006 entry.

It doesn't show when I do a cheque batch, so I can't clear it there and I can't do an adjustment because you can't adjust an RC.

Any help would be appreciated.

Candace

Hi, Candace,

Although it is unknown exactly why this occurred, the entries are not matched and will not clear to history as long as there is an amount remaining as current. A lot of time has passed and the only way to fix this is a database repair.

As you've put up with the two transactions for this long, you may want to continue doing so instead.

Thanks for your input. I thought it was wierd that it is still showing in current when it's 2 years old. If I deactivate this vendor and wait it out, will it eventually clear when I clear history? Or will I be able to delete the vendor eventually?

Thanks
Candace

Hi, Candace,

The transactions won't get cleared to history as they are not perceived as being matched so the answer to both of your questions is no.

Hi Candace

If it is any consolation, I know that this kind of data corruption occurs when you try to reverse a check in ACCPAC Plus Accounts Payable when the check was issued in Adagio Payables.

Just in case you are still using ACCPAC Plus (which is database compliant with Adagio and will still work as long as you are not using Adagio JobCost), make sure not to reverse checks there.

Steve

I have also seen corruption of this kind when there were two checks with the same number and both were reversed. Avoid reusing check numbers. Note that a zero in front of the number makes it a different "document number".