Data Exchange Definition issue

(0) Share

Report

Posted on by Juliem

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

All responses (5)

Answers (1)

GBFServices 15 on at

Like (0)

Report

RE: Data Exchange Definition issue

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

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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:

Hope this helps.

Thanks,

Steve
Juliem 231 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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