CTX format for ACH remittances

  • CTX format for ACH remittances

    Posted by joe.scheidecker@guardiannrg.com on December 3, 2020 at 11:53 am
    • Joe Scheidecker

      Member

      December 3, 2020 at 11:53 AM

      Hi GP friends,
      I am wondering if anyone knows if there is a way to provide remittances to our vendors in CTX format, inherent to GP, without having to use a third-party EDI provider? Currently we pay vendors via ACH and send a text file to Wells Fargo with the payment information, and email the standard GP remittance form to the vendor. More and more vendors are asking us to send CTX formatted remittances instead of emailed forms, so they can fully automate their payment application process. Has anybody done this without the use of EDI?

      ——————————
      Joe Scheidecker
      Accounting Manager
      Guardian Energy
      Hankinson ND
      ——————————

    • Beat Bucher

      Member

      December 14, 2020 at 1:30 PM

      Hi Joe,
      I’ve been using EDI formats many years ago with GP, and the CTX format looks nothing else than an EDI format, just called & coded differently.Ā 
      CTX_Parcel_Payment_Guide.pdf (fedex.com) andĀ  here Treasury Software
      and also here : Slide 1 (georgiapower.com)
      TBH, when looking at those definitions, I don’t see an easy way you’d be able to produce those files out of GP without a lot of manipulation..
      There are likely 3rd-party software that you can install that would allow you to pull data from GP and generate those CTX files..Ā 

      PS: Check out this community thread which deals with the same topic: (+) Setting up CTX file for EFT – Microsoft Dynamics GP Forum Community Forum
      Also, blogged about this back in GP 2010 era time.. Dynamics GP Land: Problem with Dynamics GP 2010 EFT Payables CCD+ CTX File Format
      ?

      ——————————
      Beat Bucher
      Business Analyst, Dynamics GP SME
      Montreal QC/Canada
      @GP_Beat http://www.gp-geek.com
      Montreal QC GPUG Chapter Leader
      MBS MVP (2015-2018)
      All-Star 2013
      ——————————
      ——————————————-

    • Blair Christensen

      Member

      December 15, 2020 at 10:14 AM

      I’ve done both EDI and worked with Wells Fargo specifically for ACH and check payments.Ā  You’re welcome to contact me directly and I can show you what we send them every day.Ā  It was all developed by me to conform to the bank’s specifications.

      ——————————
      Blair Christensen
      Database Administrator
      Oppenheimer Companies, Inc.
      Boise Idaho GPUG Chapter Leader
      ——————————
      ——————————————-

  • 0 Replies

Sorry, there were no replies found.

The discussion ‘CTX format for ACH remittances’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!