We created a batch payment, that ultimately didn't go through from our bank account because there were errors in it. We subsequently created a new batch payment that went through. How do we delete all the first batch as payments are now doubled up?
We created a batch payment, that ultimately didn't go through from our bank account because there were errors in it. We subsequently created a new batch payment that went through. How do we delete all the first batch as payments are now doubled up?
Okay, thanks for your help.
Jason,
Thank you for the pic. So a Payment was posted and based on the Find Entries, the offset was the Bank Ledger Entry. Sadly, you cannot reverse this entry because it posts to a sub-ledger. The only solution I can this is to copy all the General Ledger entries to a Config. Package to Table 81 that reverses all the entries. It is the quickest solution I can think of.
Thanks,
Steve
Hi Steve
There are multiple payments that were made in the batch, but an example to one vendor is here (Doc # PMT000034):
You can see there are multiple entries associated with this PMT000034:
Whenever we drill down into these and try to reverse, we hit the error message that you can't reverse unless posted from a journal. because there are so many entries, we want to reverse the whole batch at once.
A work around we have used is to individually post refunds and assign it to the payment, but that's time consuming.
Regards
Jason
Jason,
Question - You state the Payment Journal was posted so you have a entry in the General Ledger and Bank Ledger for the transaction? If the entry posted it has to have recorded an entry. Reversing entries that hit a sub-ledger is not possible. Can you send a pic of the entry that has posted.
Thanks,
Steve
Hi Steve
The payment was raised as an EFT so there is no check or any entries on the check ledger. The bank EFT didn't actually occur, we stopped it because there was an error. However, in BC it was posted (so as far as BC is concerned, it happened). So, we are trying to reverse/cancel/undo the EFT batch payment, but we can't seem to get that happening. We also can't reconcile that to any bank statement, because it's not rfelcted at the bank level (was stopped).
Regards
Jason
Jason,
I have encountered this before and I since the reverse Register will not work since you are hitting a sub-ledger transaction, I tell my customers to Financially Void the payments to reverse the Document off the Bank Account and reinstate the Vendor Payable. However, if the Vendor Payable is not the issue, just the Bank balance, make sure you click VOID CHECK ONLY.
This will reverse the Bank Ledger Check entry and Void transaction.
Hope this helps.
Steve
Thanks Gavin, however, in both cases we get this error:
Hi,
If the first batch of payments weren't applied you can reverse the register via the "G/L Registers" page i.e.
If they were applied, or if you want to do them individually you can use the "Vendor Ledger Entries" page to reverse them i.e.
Hope this helps.
Thanks
Gavin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156