Deleting a batch payment

(0) Share

Report

Posted on by JasonW

120

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?

All responses (8)

Answers (1)

JasonW 120 on at

Like (0)

Report

RE: Deleting a batch payment

Okay, thanks for your help.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Deleting a batch payment

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
JasonW 120 on at

Like (0)

Report

RE: Deleting a batch payment

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
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Deleting a batch payment

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
JasonW 120 on at

Like (0)

Report

RE: Deleting a batch payment

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
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Deleting a batch payment

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
JasonW 120 on at

Like (0)

Report

RE: Deleting a batch payment

Thanks Gavin, however, in both cases we get this error:
Gavin 2,339 on at

Like (0)

Report

RE: Deleting a batch payment

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