Monday, May 20, 2013

Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format

In May 2012, I wrote about an apparent bug in the Dynamics GP 2010 Payables EFT CCT+ file format that prevented my customer from using the CTX file format (CCD+ with the Detail Line Addenda option).  At the time, the bug affected GP 2010 SP 2, as the CTX format option had been added with SP 2.

I received an inquiry today from a GP customer asking if the bug has been fixed.  The customer is hoping to be able to use the CTX format to send detail remittance to their vendors electronically as part of their EFT transmission.

I have tested GP 2010 SP3, and it appears the bug is still present.  The "Addenda Count" calculation only outputs a "0" instead of indicating the number of addenda lines.

6221231231231234567890  00000500151EFT  0000TEST EFT VENDOR

Just in case, I checked the SP3 and post-SP2 hotfix documentation, and see no mention of a fix to EFT.

I also just tested GP 2013 RTM (version 12.00.1295), and the CTX Addenda Count bug also exists in that version.  Despite a few additions to the Generate EFT Files window, they apparently didn't get around to fixing the Addenda Count calculation.

So for now, the Dynamics GP Payables EFT CTX file format is still not compliant with the NACHA standard. 

If you are looking to implement the CTX format, submit a support case with Microsoft.  They should be able to confirm that it is a bug and not charge for the case, and you should theoretically be notified in case there is an update to the issue.

Steve Endow is a Dynamics GP Certified Trainer and Dynamics GP Certified IT Professional in Los Angeles.  He is also the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.

1 comment:

ICAN Software Solutions said...

Has Microsoft resolved this on GP 2015 or 2016?