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?