Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

How to create a Canada ACH export file

Posted on by 126

Hi Everyone -

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

Has anyone found a workaround to this ?

  • Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 11,768 Super User 2024 Season 2 on at
    RE: How to create a Canada ACH export file

    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

  • navnah01 Profile Picture
    navnah01 126 on at
    RE: How to create a Canada ACH export file

    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
    Alireza Eshaghzadeh 11,768 Super User 2024 Season 2 on at
    RE: How to create a Canada ACH export file

    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
    navnah01 126 on at
    RE: How to create a Canada ACH export file

    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

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 11,768 Super User 2024 Season 2 on at
    RE: How to create a Canada ACH export file

    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans