Open Forum

A Shot of Business Central and A Beer Podcast
Back to discussions
Expand all | Collapse all

Nav 2018 ACH Integration with KeyBank

  • 1.  Nav 2018 ACH Integration with KeyBank

    Posted 16 days ago
    I was wondering if anyone has any tips or tricks regarding integrating ACH payment through KeyBank. We are at the beginning stages and even a sample upload document would be helpful.

    ------------------------------
    Haley Bolton
    Arctic Fisheries Ltd.
    Buffalo
    ------------------------------


  • 2.  RE: Nav 2018 ACH Integration with KeyBank

    NAVUG ALL STAR
    Posted 15 days ago
    Edited by Steven Chinsky 15 days ago
    Haley,

    I do not have a Key Bank but with NAV or BC their is an Export file. It might not be exact to the Banks NACHA requirement. Attached is one from Wells Fargo (layout). The attachments should help you and your Partner update the Object. Again, mine is Wells Fargo and you need the layout for Key Bank. Then you can run an EFT Export and match the layout to Key and the Partner can update where necessary.

    Hope this helps.
    Steve

    ------------------------------
    Steven Chinsky
    Manager
    Wipfli
    Mansfield MA
    NAVUG/BC Programming Committee Member
    NAVUG All-Star, Granite Award Recipient, MCP, DCMP
    ------------------------------

    Attachment(s)

    pdf
    ach_ffsup_single_batch.pdf   134 KB 1 version
    txt
    ACH0000025.txt   960 B 1 version
    Original Message


  • 3.  RE: Nav 2018 ACH Integration with KeyBank

    Posted 13 days ago
    Haley

    I concur with Steve. Each bank will have there own mapping of the fields. But remember it's an ASCII file, so you could have up to 4 different flavors. Once you have the mapping document from Key Bank, you can look at the Standard NAV EFT file and Steve's Wells Fargo File to see the differences. You made need a developer or not.

    Remember, there's lots and lots of testing to be done between yourself, Key Bank and the users.

    Good Luck!

    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Original Message


  • 4.  RE: Nav 2018 ACH Integration with KeyBank

    TOP CONTRIBUTOR
    Posted 12 days ago
    Edited by Cynthia Priebe 12 days ago
    @Haley Bolton you may be able to get a sample file (output) from Key Bank along with their ACH implementation guide. Frequently banks can provide this for you. And as @Alfredo Zelaya indicated, there will most likely be much back and forth as you confirm that the file you tweaked through the data exchange definition with the bank. Even when you think you have it perfect, they always seem to find something ;-)

    And you may find this to be helpful:
    https://msdynamicsworld.com/story/tear-those-paper-checks-dynamics-365-business-central-makes-ach-easy​

    You've got this!

    ------------------------------
    Cynthia Priebe
    New View Strategies
    "The NAV & BC training and process experts"
    ------------------------------

    Original Message


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