_UPDATE: An anonymous commenter claiming to be a Microsoft employee stated that this appears to be a bug in GP 2010 SP2, with no planned fix as of May 2012. Users on GP 2010 SP2 or later should utilize the CCD+ format with the “Detail Line Addenda” option unchecked. _
For those still using an earlier GP 2010 release, a separate bug in the CCD+ format leads to multiple addenda lines being exported instead of the single line required by the CCD+ specification. As my client has not transitioned to GP 2010 SP2 yet, they are unable to utilize CCD+ and must revert to the CCD format. Unless your vendors require the additional data provided by CCD+ or CTX formats, CCD should suffice. However, if your vendors can process remittance details through a CTX file, waiting for a fix is necessary unless manual file editing or using a non-standard file with your bank is feasible.
While this issue may not be widespread, I am sharing my experience to assist others facing similar challenges.
I am implementing Dynamics GP 2010 EFT Payables for a client who wants to send multiple remittance lines within the ACH file (ACH “addenda” records). Since their bank supports this feature, we considered utilizing this functionality for vendors capable of receiving electronic remittance advice through ACH downloads.
Microsoft introduced a feature in GP 2010 SP2 within the EFT File Format setup, enabling the export of multiple addenda records. Referred to as the “CTX” file format, this functionality aligns with an update to the ACH file format standard in late 2007.
http://support.microsoft.com/kb/2551488
However, it seems there’s an issue with how GP 2010 implements the CTX file format.
When configuring the CTX file format to include multiple addenda records, the number of addenda records per payment must also be transmitted. For instance, a $1,000 payment covering ten invoices would require an addenda count value of “0010” in the “Detail” record, followed by the ten addenda records themselves.
Page 11 of the NACHA CTX file format documentation highlights this:
http://www.regaltek.com/docs/NACHA%20Format.pdf
Specifically, “Number of Addenda Records” (Field 8) is not mandatory for CCD+ (which supports only one addenda record). However, utilizing the GP “Detail Line Addenda” option activates the CTX format, necessitating this field.
Unfortunately, Dynamics GP EFT seemingly lacks the functionality to send this addenda count value within the detail record. Attempts to add the field result in a default value of “0000”, as demonstrated below (highlighted in red):
6221231231231234567890 00000306001EFT 0000TEST EFT VENDOR 011123123120000001
Despite using the “Addenda Count” Calculation Type in the EFT File Format setup window, it proves ineffective.
It appears that the Addenda Count calculation type primarily serves to sequentially number addenda lines within those specific lines. It doesn’t provide an overall count or function correctly in other line types.
Despite exploring and testing other Calculation Type values and options like Data Fields, I haven’t found a solution for transmitting the required addenda count value.
I posted this issue on the Community Forum, but haven’t received any responses. As the client prefers not to initiate a support case, I will disable the “Detail Line Addenda” option for now.
This situation suggests a bug or incomplete support for the CTX file format. If you have encountered this, possess further insights, or know of a workaround, please share your experience.
_Steve Endow is a Dynamics GP Certified Trainer and Dynamics GP Certified IT Professional based in Los Angeles. He is also the founder of Precipio Services, which specializes in Dynamics GP integrations, customizations, and automation solutions.