Open Forum

Expand all | Collapse all

Improve Data Exchange Defintion: EFT (ACH)

  • 1.  Improve Data Exchange Defintion: EFT (ACH)

    SILVER CONTRIBUTOR
    Posted Mar 07, 2019 11:16 PM
    #DataManagement
    Dear All,
    Did you know that EFT (ACH) format vary from institution to institution in certain local versions of Business Central (NAV)? This makes it impractical to create all possible combinations for EFT file output through Data Exchange Definition. This means that development or external service is needed still.

    To avoid this, I have posted an idea for Microsoft. If you want, you can read and up-vote it here - this can be a huge help to your or fellow-organizations (both Partners and Customers) using Business Central (NAV):
    https://experience.dynamics.com/ideas/idea/?ideaid=1a95001a-5741-e911-867a-0003ff68b9cf

    Thank you!


    ------------------------------
    Iaroslav
    ------------------------------


  • 2.  RE: Improve Data Exchange Defintion: EFT (ACH)

    Posted Mar 08, 2019 07:24 AM
    I second this 100%.   We need a format for CIBC.   There should be an easier way to create these formats rather than having to do dev work (create one's own IP!) just to have a format for the customer.     Support of Canada should be accessible through BC.

    ------------------------------
    David Spangler
    Velosio
    Dublin OH
    ------------------------------



  • 3.  RE: Improve Data Exchange Defintion: EFT (ACH)

    SILVER CONTRIBUTOR
    Posted 2 days ago
    Dear All,
    We great news on this. Thank you to all who have voted! Microsoft has listened to this idea and we all can now take advantage of this function in the new release of the product! =)

    ------------------------------
    Iaroslav
    ------------------------------



  • 4.  RE: Improve Data Exchange Defintion: EFT (ACH)

    Posted 6 hours ago
    You are so right. I am wrestling with PNC Bank's ACH Department now. The Bank Import/Export setup allows US EFT CCD, That is the only option that I could get to generate a file. It inserts a "1" as a prefix to the company EIN. That throws the Export file 1 digit to the right of where the EIN should begin in the NACHA file.
    There is no way to build the export file, line by line, as in Great Plains. One-size-fits-all. So PNC is working with me to build a custom template.

    Thanks, Laroslav, for pushing Microsoft on this. Hope we don't have to wait until October for the release of the improvements.

    Regards,
    Steve Simon

    ------------------------------
    Steve Simon
    Pres.
    PDG Consultants, Inc.
    Clearwater
    ------------------------------



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