Generate EFT file does nothing.

Hello Everyone,

Today I would like to talk about an issue I have seen where Generating the EFT File does not generate the file; it appears to just do nothing.

In this blog, I will tell you what tables are involved with the EFT File and I will explain three common scenarios that will cause the EFT file not to generate as well as the resolution. 

The Tables involved:

1. CM20202 - holds each transaction that is in the EFT File.
2. CM20203 - is the batch header record.

The 3 main causes and solutions:

1. The most common scenario we see is due to a user voiding a check that is in the EFT run before the EFT File was generated. If it was voided, the EFT File will not generate until the record is removed from the tables.
   1. You can use a statement like the one below to see all record in the PM30200 that have a corresponding record in the CM20202 that is voided.

                           SELECT * FROM PM30200 WHERE VCHRNMBR in (SELECT DOCNUMBR FROM CM20202) AND VOIDED = '1'

                    b. Once you have determined the voided records that exist in the CM20202, you can create a statement to remove these records.

                            DELETE CM20202 WHERE DEX_ROW_ID = 'Dex_Row_ID Number here'

                     c. Once the voided transaction is removed from the CM20202, the file should generate without issue.

2. The next scenario is a setup issue. The Remit to Address ID does not have the correct File Transfer Method assigned to the Vendor. This needs to match what you have assigned for the File Format in the Checkbook EFT Maintenance window.
   1. Checkbook EFT Maintenance window Financial >> Cards >> Financial >> Checkbook >> enter or select a checkbook ID >> EFT Bank button >> Payables Options button.

                 b. If the File Format is set to Single Format, then the Vendor File Transfer Method would be set to Not Specified.
                 c. If the File Format is set to Based-on Vendor, assigned with one of the options, it needs to match on the Vendor record for the format that is selected.

               d. The same is true for Receivables.

3. The last scenario is the EFT File Format gets corrupted or damaged.
   1. The easiest way to test this scenario, create an EFT File Format in the test company using the NACHA defaults.
   2. If the file generates successful, you know the File Format in the live company is damaged and needs to be recreated.

I hope this information is helpful and will save you a call to support.

Thank you!

Microsoft Support Engineer | Brandon Jarrett