Open Forum

 View Only
  • 1.  Getting Started with Vendor EFT

    Posted 9 days ago
    We are working on setting up electronic payments for our vendors and I am getting a little overwhelmed with all of the different file formats available.  Is there a difference between NACHA-CCD and NACHA-PPD?  Is the file format specific to the vendor receiving the payment or is it really based on the issuing bank?  Also, we are looking for best practices for obtaining vendor information related to EFT setup and what verification steps you take when setting up a vendor for their first electronic payment.

    Thank you.

    Vicki Hillary
    RDV Corporation
    Grand Rapids MI

  • 2.  RE: Getting Started with Vendor EFT

    Posted 8 days ago
    Typically CCD format would be used for your Trade Vendors with Corporate Bank Accounts at their bank and PPD format for your Employee Vendors who more likely have personal accounts at their banks. The Payables EFT setup for your Checkbook would then be File Format Based on Vendor not Single Format. It is your bank however that will tell you what they want in your EFT file.

    Thaddeus Suter
    Retus, Inc

  • 3.  RE: Getting Started with Vendor EFT

    Posted 8 days ago
    We use an Abobe Sign template and send it to the vendor for them to complete. In addition to the standard NACHA file there is a capability to also have addendum records included but we have found there are various bugs in GP with addendum records. So I would stay away from these.

    David Shapiro
    Director of Information technology
    Barron Collier Partnership
    Naples FL

  • 4.  RE: Getting Started with Vendor EFT

    Posted 7 days ago
    Microsoft said they would fix those bugs in the CTX format but never came through.  Ask your vendors to provide an email address for sending remittance advices.  When you run EFT payments, you can have the remittance forms emailed to each vendor.  If they provide a dedicated email, you won't need to maintain it when the contact leaves the vendor.  If you maintain your own EFT formats, an enhanced editor like Notepad++ will be a huge help.  Most banks provide file mapping documentation and the GP mapping interface is pretty good.  Knowledge of the PM tables is helpful and installing the SDK that comes with Dynamics GP provides very good table reference.

    Lou Spevack
    American Council on Education
    Washington MD

  • 5.  RE: Getting Started with Vendor EFT

    Posted 7 days ago
    Hi  Vicki,
    Your bank should be able to give you a spec sheet for the files.  You should be able to follow their instructions to update each field in the setup window.  Each bank typically has their own requirements.  They should also be able to process a test file to ensure it works properly.

    John Buchman
    Rio Marine

  • 6.  RE: Getting Started with Vendor EFT

    Posted 7 days ago
    Edited by Kevin Pritchard 7 days ago
    Hi Vicki, 

    Greetings from another Michigan West Sider :)

    I work for an ISV that takes care of all the legwork with setting up ACH. You'd still be sending payments directly from your bank account to your vendors. We integrate directly with GP so you'd basically just pick what you want to pay, upload that batch to our system, and we'd handle file generation and delivery to your bank (after an optional approval) . We also have a self service vendor portal to make onboarding your vendors to ACH easy, and secure. We're also compliant with the new NACHA encrypted at rest requirements if that is a concern of yours as well. 

    You can view more info here:

    Or feel free to reach out to me directly, happy to help if it makes sense, otherwise, no worries. 


    Kevin Pritchard

  • 7.  RE: Getting Started with Vendor EFT

    Posted 6 days ago
    Thanks for this interesting information! I will also try to same.

    marlas Stinson

If you've found this thread useful, dive deeper into User Group community content by role