Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Setting up CTX file fo...
Microsoft Dynamics GP (Archived)

Setting up CTX file for EFT

(0) ShareShare
ReportReport
Posted on by Galina 1,075

This is for GP10.0 

We would like to implement the ACH with our bank, but for this we need to generate NACHA file. The way we would like to do it - in CTX format. Unfortunately, it's not on the predefined format list for EFT Files that comes with EFT Payables Management.

Does anybody have any idea how to set it up? Where would I get the specs, or maybe a download. We shouldn't be the only ones that want to use this feature in GP10.0... Is there a way to work around it?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Setting up CTX file for EFT

    I wanted to follow up my previous post about Customer Source article 2551488 and CTX files.  Microsoft considers the fact you can customize the PPD+ format as a CTX solution.  This may or may not work for you solution.  In my case I was actually wanting to remit credit card information and ended up just using a PPD format and generated a seperate remittance file via vb as the time the user genarates the file.  

  • Jason Buckingham Profile Picture
    Jason Buckingham 1,340 on at
    Re: Setting up CTX file for EFT

    Glad to find this post.  I am currently setting up a client with a CTX format.  They have one vendor who needs the CTX format and all others take standard NACHA PPD.  Unfortunatly, they are on GP10.  I understand that the CTX format is the same as the NACHA PPD with the exception of the addedum records.  I have not found how to get this to work right, yet.  I will watch this post and update if I have found out anything.

  • sueconrod Profile Picture
    sueconrod 335 on at
    Re: Setting up CTX file for EFT

    You want to talk to the "Treasury Department"  I already have the EFT specs for Payables for Wachovia and just looked and we are using the format type:  US-NACH-PPD.  it is a flat file with a format class of Corporate Account and a Max length line of 94.  So, they should have the specs to send you.  I did not set this up originally so I don't have the original specs from Wachovia or I would send them over.   But it all depends on who the orignal bank was since Wachovia has also been merging with other banks and now they are about to change again with Wells Fargo.

    I agree, when I was doing consulting I only ran into one issue with the specs and that was for a Northern Trust Account and we were able to take one of the Standards in Great Plains and make a one line adjustment to the format and then everything worked.

    The only issue I ran into with Bank of America is that each of the BOA accounts was just a little bit different each time due to the fact that they had merged from different banks.  

  • Galina Profile Picture
    Galina 1,075 on at
    Re: Setting up CTX file for EFT

    Thanks, I'm excited to see that MS finally decided to address this. We are planing to go to GP2010 at the end of the year.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Setting up CTX file for EFT

    Anyone reading this should check out Customer Source article 2551488.  Additional functionality has been included GP2010 SP2 which helps create a CTX format.  I have not done this yet, but am working on it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Setting up CTX file for EFT

    Unfortunately, I didn’t get anywhere in GP either.  

    It might be possible to create an excel file that reads the tables and generates a compatible file.  We didn’t bother taking it that far just for a single vendor.

    Good luck,

    Michelle

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Setting up CTX file for EFT

    Not from my end.

    But the others who contributed here might be able to help.

    Ian.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Setting up CTX file for EFT

    Ian,

    I see that the last post was almost a year ago.  Is there any additional information regarding creating a CTX EFT format?

    Rod

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Setting up CTX file for EFT

    I completed one for a US bank with addenda lines... I'll have to review it tonight and will post again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Setting up CTX file for EFT

    Has anyone had any sucess setting up a CTX EFT format?  I am very close to getting it done, but have hit a snag: 

     The CTX specification calls for a sequential number column that increments for each Addenda record.  0001, 0002, 0003 etc.  And that it be reset for each entry detail record.

     I've been digging through the calculation fields, but haven't found any way to add this information.

     Has anyone else been able to accomplish it?

    Thank You,

    ~ Michelle

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans