web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Delete Voided Batches From Generate EFT Files

(0) ShareShare
ReportReport
Posted on by

An EFT batch was posted, then one of the payments was voided and recreated using the same batch name, but posted at different times.  When trying to generate the EFT File, the one batch ID was checked and the Generate EFT File button was pushed.  A message appeared stating "The Transaction File has been generated with 0 transactions and is in the following location:  Review the file and transmit to your financial institution to complete the transfer."  There is a file location set for the EFT information.  The only way the file could be generated for these payments was to void all of them and recreate under a different batch ID than before.  In the Generate EFT File window, both batch IDs were listed, one that would not generate the file and the next one that did generate the file.  How do you delete the batch that generated with 0 transactions from this window?  After generating the file, the batch ID is still listed in the window, even after logging out and back in.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Good question!

    Whenever I was in this predicament, I cheated and deleted the bad EFT batch from the SQL tables. The tables involved are CM20202 (checkbook transaction electronic funds transfer) for the line items and CM20203 (Checkbook eft transaction batch) for the EFT batch header.

    Kind regards,

    Leslie

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans