Finance | Project Operations, Human Resources, ...

AX Payment file format

(0) Share

Report

Posted on by Jingjing

We need to create an ACH payment file out of AX that can be imported into our US bank portal.

The file-format in AX is called “NACHA (US)” and it is assigned to the method of payment “ACH”. The file format NACHA (US) also requires a selection in the “payment specification”-field and

I choose “Standard NACHA PPD”.

But when I tried to import it into the US bank portal I received an error that there is an issue with the record length in our ACH test file. Our bank provided a NACHA ACH payment file sample, unfortunately, the sample looks slightly different to our payment file generated from AX.

Any insight will be helpful and I appreciate any advice.

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jingjing,

Which exact version of AX 2012 are you running? I'm not familiar with this file format, but probably there are some changes which are updated in the latest version of AX 2012.

Was this reply helpful? Yes No
Jingjing 5 on at

Like (0)

Report

Thanks Andre.

We are using Microsoft AX 2012. Our European companies do not have issue when they generate payment file from AX 2012 and import to European banks. We are using the same ERP system. Not sure why this happen.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jingiing,

The 'old' payment file format configuration that is available in AX2012 is something that cannot be adjusted without the help of a developer. If the format does not fit the requirements of your bank then I would recommend to talk to a technical expert (developer) in your company who could possibly help you with that.

Best regards,

Ludwig

Was this reply helpful? Yes No
Jingjing 5 on at

Like (0)

Report

Thank you Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jingjing,

The European companies are, I think, not using the NACHA (US), but another format.

You didn't answer the question which exact version of AX 2012 you are using. There were multiple main releases and several cumulative updates. Are you using AX 2012, AX 2012 R2 or AX 2012 R3 and with what exact CU?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning Jingiing,

Has your issue been resolved or do you still need some feedback from the community?

Would be great if you could keep us updated.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
C. Shenk on at

Like (0)

Report

Hello Jingjing,

Good afternoon - checking on this one. Were the suggestions able to provide what you needed? If so, please considered marking which post provided the resolution, and let us know the status when you have the chance. Thank you!!

Cheers,

Conor Shenk

Was this reply helpful? Yes No