Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Data Exchange Definition issue

Posted on by 224

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 224 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 224 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans