Announcements
No record found.
What is the sort order for the grid on the Generate EFT Files screen? Is there any way for the list to be in reverse date order so the most recent batch will always appear first?
Hello Richard,
The grid is pulling the EFT batch header record from the CM20203 EFT header table, and sorted first by the batch total (BCHTOTAL) and then by the batch ID number (BACHNUMB). I believe you would need a dexterity customization to change the sort in that window. The window is also restricted by checkbook ID, so I find it unusual that there would be a lot of records in the window for the same checkbook ID, unless users are posting EFT batches in payables and NOT generating the EFT files. If there are old orphaned batches in this window, you can generate the EFT file for that batch and then just do nothing with the EFT file. When you generate the EFT file, the data is then dropped out of the CM20202/CM20202 tables for the batch ID's selected.
Let me know if any further questions, or please 'mark as answer' if this helps you. Thank you in advance.
CherylMicrosoft Support - Payables Management
Cheryl, are you saying if the user generates the EFT file that the batch header record is deleted from the CM20203 table? In this case the client has no use for the EFT file created by GP. This file needs to be created with unique fields required by PaymodeX. There is no way to get GP to provide the required fields. I will tell them to generate the EFT file and then simply discard it.
Yes, generate a file and see the records are dropped off the window (ie. out of the CM20203/CM20202 tables).
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 475 Most Valuable Professional
André Arnaud de Cal... 399 Super User 2026 Season 2
CU10121822-0 374
