Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Data Exchange Definition issue

(0) ShareShare
ReportReport
Posted on by 231

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

  • GBFServices Profile Picture
    GBFServices 15 on at
    RE: Data Exchange Definition issue

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

  • Juliem Profile Picture
    Juliem 231 on at
    RE: Data Exchange Definition issue

    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?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Exchange Definition issue

    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 231 on at
    RE: Data Exchange Definition issue

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Exchange Definition issue

    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

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans