Hello,
Joseph is correct. However, there is one part being overlooked with the approach.
Since it is over applied, when you void both the documents, it will update the Amount Remaining (Current Transaction Amount) with the incorrect amount. The Invoice in the end will be $5,000 instead of 2,500 because you are voiding/unapply two documents, both for $2,500.
When you go to attempt to void the Invoice, a message will pop up stating "The document cannot be marked for voiding. It has been either partially applied or is on hold" because the Amount Remaining has to match the Document Amount to void an Invoice in the Void Open window.
My suggestion would be:
- Choose one Payment that should not be applied and void it.
- That should bring the Invoice back to open with 2500 remaining.
- Update the Current Amount on the Invoice to be 0.00.
- Run Check Links on the Payables Transaction Logical to move it to history.
- You should check the PM20100 for a record associated with this Invoice as if there is a record Check Links will not move it.
- Be sure you do this in test first as we do not know what check links will do until afterwards and the only way to undo check links is to restore.
- Verify this solves the issue.
If you cannot run Check Links:
- Void both payments.
- Update the Current Amount on the Invoice to be the Document Amount.
- Void the Invoice.
- Re-enter as needed.
Another option if you do not want to void.
- Remove history on the Invoice and Payment. Make adjustments to the Bank and let those flow to the General Ledger.
- Re-enter as needed.
The negative Joeseph is referring to in the Bank Rec will only occur if the Payment has been reconciled. If it has not been reconciled, it will mark that transaction as reconciled and drop out of the Bank Reconciliation window. The negative is fine because it will wash with the new payment that is entered and can be selected on the next reconcile as they will net to 0.00.
NOTE: If you sent both of these payments out and they were cashed, you still need to re-record these as you paid that vendor with both payments.
Re-entering the payments, you can use Manual Payments, so you do not have cut new checks. You also will need to allow duplicate check numbers in the checkbook if you want to use the same check numbers. Or you can use the same number and a * if that works for you.
I hope this helps!
Thank you!