web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to create a Canada ACH export file

(0) ShareShare
ReportReport
Posted on by 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)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,849 Super User 2026 Season 1 on at

    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)

    pastedimage1628175480059v1.png

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

  • navnah01 Profile Picture
    136 on at

    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

  • Alireza Eshaghzadeh Profile Picture
    14,849 Super User 2026 Season 1 on at

    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

    pastedimage1628176257660v1.png

    Regards,

    Alireza

  • navnah01 Profile Picture
    136 on at

    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

  • Alireza Eshaghzadeh Profile Picture
    14,849 Super User 2026 Season 1 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 699

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 548 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans