I have an AP check fully applied to 5 regular AP invoices (not from POP). A user tried to void the check which is dated about 2 years ago but not yet reconciled. When they hit process they get the DBMS 2627 error. Once that happens, one of the invoices is copied from PM30200 to PM20000 (exists in both tables). The distribution record is moved from PM30600 to PM10100 (no longer exists in history). All the other information for check and invoices appears to stay in the history tables. I do get the duplicate error when using the Transaction by Vendor Inquiry window since the one invoice is in open and history. When I look at the check and drill back into the apply window, the voucher number is showing for this particular invoice but not the document number. Running checklinks brings that document number back but everything else stays as is.
I have run checklinks on the entire Purchasing series. I have cleaned out activity tables and restarted SQL. I have deleted and re-created the PM Keys table. I remove the extra record in the PM20000 table, copy the distributions back to history, delete the distributions from open, and run checklinks again. Of course, I no longer get the duplicate key error in the inquiry window but as soon as I try to void the payment, it all goes back to what is described above. I tried looking through each table in open and history to make sure it wasn't in open and was in history.
Anything else to try? Accounting wants to void the check rather than create offsetting transactions because they are worried about audit issues.
Thank you