Why are there lines with 9999999999999999 at the bottom of my ACH payment file exported for EFT from Business Central?

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.

I hope this new information speeds you along on your journey to using BC The Righter Way. Learn more through "Finding the Righter Way", a Dynamics Community Blogs