Automating ACH file sending process to all the banks - AX 2012.

(0) Share

Report

Posted on by Community Member

Dear All,

We need to provide EFT process in AX 2012 for one of our US customer implementation. Basically i am having the following questions.

1. Since many banks invovled in EFT process, do we need to customize the ACH file format for each of the bank?

2. How the bank gets these ACH files automatically which was generated in AX 2012, Means what process they normally use, something like FTP/API or manually sending the file?

3. What is the best methodology to cover the above scenario (multiple banks/Multiple ACH file format) something like any Add in suggested?

Also, i heard that the customizations should not be a big one since all commercial banks in North America . But how the bank will receive these files automatically. we would like to automate this file sending process. please let me know what could be the suggested proven methodology.

Thanks for your help.

Thanks

Regards

Uday

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Joris dG 17,775 on at

Like (0)

Report

The process for creating the bank files is fairly well designed. You do have to extend some base classes (CustVendOutPaym and CustVendOutPaymRecord) which is a decent pattern. The bank file creation process hooks into the journal so that you cannot post the journal without creating the file, and after creating the file you cannot just delete the journal without posting it.

There is no mechanism for automatic sending of the files, unfortunately. What we have done in the past is just have AX generate the file on a shared folder, then have a windows batched process that picks up the files and FTPs them.

Some banks may except one of the default file formats, but typically I've seen it customized for each bank. Once you have the classes created (we auto-generate them from a layout setup program we created) you need to set them up on the method of payments.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Hi Joris, Could you please provide a link or document on "The process for creating the bank files is fairly well designed" I have set up the nacha file format for vendor ACH pay. However, I am stuck where the system is throwing an error "company statement name" is missing.

I also created an outbound port for Vendpayment using SEPA, but I later notice that it is used in EURO currency!! technet walkthrough on this isn't applicable to US format looks like. please help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When you get the error "company statement name is missing", you have to add the address to the Bank details before you can add the company statement name into the field. Until the address is added, that field is disabled.

Was this reply helpful? Yes No