Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

CTX EFT File Format

Posted on by 75
Hello!
I am trying to set up the CTX format for our Bank which requires CTX in order to use multiple addenda records.  Has anyone been able to modify one of that standard NACHA files(PPD, CCD) to function as a CTX file?  Does Microsoft address this?
Thanks!
Categories:
  • Suggested answer
    RE: CTX EFT File Format

    Hello,

    If your EFT file format requires the total count of the Addenda lines in the Detail line, GP is not able to do this.   Not all CTX formats require that, so make sure to review your bank's requirements to make sure. You would need a dexterity customization to achieve that or seek out a 3rd party for EFT that would offer that.  

    This is documented in Q34 at the end of this KB article:

    support.microsoft.com/.../guidelines-to-follow-when-you-generate-eft-files-or-eft-prenote-files

    Or in the 'number of addenda records on detail line' section of this KB article:

    support.microsoft.com/.../custom-data-fields-for-electronic-funds-transfer-eft-formats-in-micros

    Thanks

    Cheryl W

    Microsoft Dynamics GP support

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: CTX EFT File Format

    Based on Cheryl's answer, and if you don't want to spend dozens of hours in coding & customizations, you may as well turn over and look at Mekorma's MICR product which is able to generate a proper EFT file with CTX records..

  • Suggested answer
    RE: CTX EFT File Format
    [deleted]
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: CTX EFT File Format

    Hi,

    See if that older thread might help:

    community.dynamics.com/.../setting-up-ctx-file-for-eft

    And there is something here on CTX (bottom of the page):

    docs.microsoft.com/.../guidelines-generate-eft-files

    I know this is (very) old, as it wasn't available in 2010, but Microsoft should have made enhancement to the EFT format that supports the CTX record...

    dynamicsgpland.blogspot.com/.../problem-with-gp-2010-eft-payables-ccd.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans