Hi,
One of our users was entering a Manual Payment in the Purchasing module. She had already hit the Apply button and chosen a vendor invoice to apply the payment to, but she had not yet hit the Post button. At that point the system crashed, so her process was interrupted. Now the vendor invoice shows a $0.00 unapplied amount remaining, as if it has been paid in full, but we can find no record of the manual payment anywhere else. It does not show up in Transactions By Vendor or Transaction By Document inquiry. It also does not show up when clicking the "Apply" button on the invoice.
Looking in the SQL database, we see that the Manual Payment is not in any of the following tables:
PM20000, PM30200, PM00400
However it is in:
PM10200 and PM20100
I have already tried running "Check Links" on the Payables Transaction Logical File and Payable History Logical File. This removed some distribution records related to the missing payment from PM00100, but didn't help the problem beyond that. I also tried running Reconcile on the vendor in question, no luck.
Anyone have any suggestions on how we can either re-create the missing Manual Payment info, or safely remove the orphaned Apply info so that we can create a new payment and apply it to this invoice?
Thanks,
Benjamin
