Electronic Payment paid twice as much as invoice

We have a vendor that we entered in our AP data entry.  The amount entered into the data entry batch matches that amount of the auto draft from our bank account.  When we go into Invoice Payment Selection, the amount is correct and matches back to the AP data entry and auto draft.  The remittance advice printed the correct amount.  The problem is when the Check Register printed, it shows the correct amount for the Report Total, but it shows that the Printed Check Total as a negative amount of the invoice amount and the Electronic Payment Total is double the invoice amount.  This throws our batch out of balance, as our banking account now has the double invoice amount, while our accounts payable account shows the correct invoice amount.

This was posted before it could be corrected, so I don't know how to fix this, as I cannot VOID the payment because the invoice was only 1/2 of the actual payment and Sage will not let me reverse the payment if the whole check is not reversed.

I VOIDED the full amount in a test database, recalled the invoice, adjusted the invoice amount, and reissued payment.  GL & TB still tie back, but the expense account no longer balances.

How can I fix this?

  • 0

    This happened to us as well last week.  The AP Invoice information was correct, but the electronic/ACH payment was doubled.  Our AP manager didn't catch it until the DTR was run and it was out of balance.

    Since invoice and balance was correct in AP and only GL was out of balance, I went through DFDM and correct the AP Payment amount and manually fixed the ACH file (I've done this for years, so I'm very comfortable modifying this file).

    Our CFO was provided with the DTR and he will make what appears to be a one-sided entry to cash account.

    This has happened to us 1 other time, but that was on previous version and about 2 years ago.  I'm assuming it's a bug.