Announcements
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
Hey, were you ever able to figure this out? I am having a similiar issue as well.
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?
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:
Hope this helps.
Thanks,
Steve
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?
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156