Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Deleting a batch payment

(0) ShareShare
ReportReport
Posted on by 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?

  • JasonW Profile Picture
    JasonW 120 on at
    RE: Deleting a batch payment

    Okay, thanks for your help.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    JasonW 120 on at
    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):

    pastedimage1643765678721v1.png

    You can see there are multiple entries associated with this PMT000034:

    pastedimage1643765752902v2.png

    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    JasonW 120 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

    pastedimage1643646467967v1.png

    This will reverse the Bank Ledger Check entry and Void transaction.

    Hope this helps.

    Steve

  • JasonW Profile Picture
    JasonW 120 on at
    RE: Deleting a batch payment

    Thanks Gavin, however, in both cases we get this error:

    pastedimage1643590466496v1.png

  • Gavin Profile Picture
    Gavin 2,339 on at
    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.

    pastedimage1643367379892v1.png

    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.

    pastedimage1643367449819v2.png

    Hope this helps.

    Thanks

    Gavin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans