Problem With Two Customers on Paid and Posted A/R Invoice

[Matt]

We have an invoice that has been paid and posted in the Paid Items File in Accounts Receivable. The invoice amount is against one customer, but the payments were posted against two customers, one of which was the invoiced customer and one which was a different customer. This situation is causing a negative unpaid balance on the second customer's Individual Account Statement, even though there are no open invoices against that customer. Conversely, the Individual Account Statement for the invoiced customer shows a positive unpaid balance for the same amount, even though there are no open invoices against that customer either.

Anybody have any ideas on how to fix this? I can't figure out how this happened in the first place and so don't know how to create a posting to reverse it. I'm thinking the best solution is to just delete that invoice out of the paid items file but there is no way to delete just a single invoice using the Delete Old Customer or Payments Data.

[Matt]

In doing some more research on this I'm thinking I could use the Database Manager in Utilities to delete this invoice out of the Accounts Receivable paid items file. I am familiar with how to use dBase. Jeff--If I delete this invoice from the Data\ARpaid.dbf database file will that correct my problem? Would I need to delete the invoice from any other databases or is this the only one? Will deleting this invoice from this file cause problems anywhere else in the system?

[Jeff]

If you are going to delete the invoice, you will also need to delete the payments. The invoices and the payments are both in the same file. If they have been posted, the file is ArPaid, if they have not been posted yet, they will be in ArOpen.