Finance | Project Operations, Human Resources, ...

How to create a Canada ACH export file

(0) Share

Report

Posted on by navnah01

136

Hi Everyone -

We need to create a CPA005 ACH payment file for CAD-CAD transactions.

Has anyone found a workaround to this ?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi navnah01

Have you check standard export setup for payment file on Method of payment if any them can work for your purpose (e.g. NACHA IAT)?

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/create-an-electronic-payment-file-for-vendors

Was this reply helpful? Yes No
navnah01 136 on at

Like (0)

Report

Hi Alireza,

The closest we've gotten is to use the HSBC distribution service export. It has almost all of the specs required for the Canadian ACH CPA005 but we foresee issues when transmitting the file to JPMorgan.

are you aware of any other alternatives?

Best,

Nahum

Was this reply helpful? Yes No
Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi again Nahum,

Unfortunately no.

There can be a possibility to create a customized GER config for exporting the payment file based on ACH CPA005 specs and choose it as "Export format configuration" on Method of payment

Create Electronic reporting (ER) configurations - Finance & Operations | Dynamics 365 | Microsoft Docs

Regards,

Alireza

Was this reply helpful? Yes No
navnah01 136 on at

Like (0)

Report

Thank you for the prompt response, Alireza.

Which configuration are you using as a base template/boilerplate? would the best route be to import the payment model into our repository and begin that way?

Please advise.

Thank you, Alireza.

Best,

Nahum

Was this reply helpful? Yes No
Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Nahum,

We use ISO20022 Credit transfer.

There is not standard config for your purpose but there are several credit transfer config on Global Configuration repositories for data model 'Payment model' . It would be great to take this issue with GER expert to create config for export and import regarding the specs.

Regards,

Alireza

Was this reply helpful? Yes No