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?
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?
Yes, generate a file and see the records are dropped off the window (ie. out of the CM20203/CM20202 tables).
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.
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.
Cheryl
Microsoft Support - Payables Management
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... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148