Problem:
I have a bank specification for an ACH payment export file from a US bank with an Entry Class Code of CCD. The spec doesn’t say anything about rows of 9’s at the end of the file. Everything else in the file looks to be correct. I can’t find anything in the line definitions, field mapping or column definitions of the Data Exchange Definition to explain where these 9’s are coming from.
Solution:
Even though your EFT Payment Export bank specification doesn’t have the requirement outlined, the ACH export standard requires a minimum of 10 lines per file. If your file does not contain the needed transaction records to generate a 10-line file, 9’s will fill the rows until a total of 10 rows exist in the file.
The standard CCD file will include the file header, the batch header, detail line(s), batch footer and a file footer. Nines will fill the rows until a total of 10 rows exist in the file.
These 9’s are not something that you can control through the Data Exchange Definition Columns, Lines or Field Mapping. This requirement is met by the Codeunit used for US Country payment exports.
Most companies aren’t even aware of this requirement since the majority of the time, if not always, the files they generate for ACH transactions exceed the minimum line requirement.
Hi Cynthia,
I found this post through development community. I am developer in Canada, new here.
I am working on EFT setups both for transfers in Canada and USA. Couple of times I had requests to remove these 99999999999 lines. I also have requests to add Header into Canadian file format, which only allowed for US file format. I’ve had couple of different solutions for that that worked so far. However, I wouldn’t call these solutions elegant. I am wondering if you have any comments on this?
Thank you,
Lidia from Toronto
Lidia,
I am sorry I didn’t see this sooner.
I am not a developer but do know that the 99999 at the end is in the codeunit. I don’t know if that one is extensible but you might be able to copy it, modify then assign it to the data exchange definition.
As for the adding a header into the Canadian file format, if a US format will work, I see no harm in using it. The only thing the bank is concerned with is the output, not how you got there. I don’t think selecting US on the bank account for the Country Code so you can use the US format will affect anything else though you may need to check Positive Pay Export if that is being used also.
Thanks,
Cynthia