When a vendor has credit memo's automatically applied during the checkrun process, a vendor can end up with a $0 payment. These payments have a remittance printed and update the EFT table (CM20202). However, when you generate the EFT file for Canadian formats, the RBC and CIBC formats exclude the zero dollar payments in the resulting EFT file. However the "National Bank of Canada' format INCLUDES the zero dollar payments and the bank is rejecting the file. The ask is to update the 'National Bank of Canada' format to exclude zero dollar payments like the other Canadian EFT formats do. (or provide an option to exclude them).

The work-around is to put a trigger on the CM20202 table to delete $0 records when the record is inserted into the table, before generating the file. This is not a supported option.