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 / Small and medium business | Business Central, N... / Data Exchange Definiti...
Small and medium business | Business Central, N...
Answered

Data Exchange Definition issue

(0) ShareShare
ReportReport
Posted on by Juliem 377

Hi,

I need to create a new data exchange definition to export ACH payment files for CHASE bank.

This is the first time I see a file layout that needs to have the total amount and total transaction count at the header level and not footer. I'm trying to modify the codeunits to handle this but having a hard time. I added a flag to the bank account (as I don't want that logic to impact other layouts) and when it's flag, I'm using the EFT Values functions to send the information.

I need to do it in the codeunit 10320 Exp. Launcher EFT as I need to have access to the TempEFTExportWorksheet table to calculate the # of records and the amounts.

This works great, but then it calls the 10094 Export EFT (ACH) codeunit to start the export and all the values I have set with the EFT Values functions are gone.

Any suggestion on how I could handle this?

Thanks

-Julie

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

    Julie,

    Are you 100% sure that Chase NACHA ACH file specification are asking for a Header to have a Total Amount and Transaction Count. This goes against almost every NACHA EFT format. I am attaching my Chase NACHA ACH specification. Please confirm with Chase ACH contact.

    Hope this helps.

    Thanks,

    Steve

    cbo_5F00_nacha_5F00_filespecs.pdf

  • Juliem Profile Picture
    Juliem 377 on at

    Hi Steve,

    This is the file format we got from our client. Very different than the one you attached.

    I'll ask them to validate that we can use the one you attached. If so, were you able to do it just using the data exchange definition or you needed to do some modifications as well? Do you know if there is a template available that I can import instead of setting it up manually?

    cbo_5F00_csv_5F00_filespecs.pdf

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Julie,

    Wow, that CSV file will require coding to make work. I have created a Data Exchange Definition for Wells Fargo, First National Bank, Citibank, Bank of America, and others. I would ask that your Customer show their Bank Rep the following as an ACH file to import to them if OK:

    pastedimage1622034649610v1.png

    Hope this helps.

    Thanks,

    Steve

  • Juliem Profile Picture
    Juliem 377 on at

    Perfect thank you very much.

    So I guess the answer is that I will have to create the Data Exchange Definition myself, there is no template available that we can import, correct?

  • GBFServices Profile Picture
    GBFServices 15 on at

    Hey, were you ever able to figure this out? I am having a similiar issue as well.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans