web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Setting up CTX file fo...
Microsoft Dynamics GP (Archived)
Suggested Answer

Setting up CTX file for EFT

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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    The specs you should be able to get from your bank. The EFT File creation functionality in GP is really excellent. It does the job.

    You could also post here and ask if anyone is using this particular file type and would they mind exporting the format and sending it to you. You can then import it into your GP install.

    (In fact, I think we should start an area for EFT file types - when someone creates one for a particular banks requirement, they post the export here soother can use it. Especially for users outside the US)

  • Galina Profile Picture
    Galina 1,077 on at

    Thanks for your reply.

    Actually, I think that it's a great idea to share the files. I'm not sure how it's going to look from copyright point of view, though....

    The tech at the bank wasn't able to help me, sent me to GP support. I'm working with our rep at the bank, seeing that he may not get us as a customer for this option if we not able to implement, he should be motivated.

    I'm researching online, not much there...

  • Community Member Profile Picture
    Community Member on at

    Can't see a problem with copyright. Its just GP users who have done some work, sharing it with others. Maybe a moderator could advise?

    Who is your bank? Strange they wouldn't have a spec. Maybe you're talking to the wrong person. I was doing one for M&T a few weeks back, and the spec was emailed to me within 24 hours of asking for it!

    There was a previous post of a guy looking or an EFT file format. But no one had the one he was looking for. Thats what got me thinking. Lets see can we organise this.

    Talk to you soon.

  • Galina Profile Picture
    Galina 1,077 on at

    Thanks for your post.

    The bank is Wachovia, now I'm thinking I was talking to the wrong person. I'll try again.

    We already doing EFT payroll with them and it is very convenient.

    If I ever get the file, I'll post it.

  • Susan Sparks Profile Picture
    Susan Sparks 5 on at

    Hi Let me know if you find anything - I have a client that is looking for it for Bank of America - the big difference from what I can see is the additional number of addenda lines per record - I don't know of anyway to add additional ones in GP.

     

    Thanks

     

    Susan

  • Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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 on at

    Not from my end.

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

    Ian.

  • Community Member Profile Picture
    Community Member on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans