Small and medium business | Business Central, N...

DATA EXCHANGE DEFINITION FOR BMO BANK USA

(1) Share

Report

Posted on by DynamicsBC

194

Hello,

I am trying to set up a data exchange definition for BMO Bank USA in Microsoft Dynamics. I am facing some challenges with the configuration and would appreciate any guidance or detailed steps on how to properly set this up.

Has anyone worked with this bank before or could provide advice on how to configure the data exchange definition?

Thank you in advance for your help!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps: https://www.forvismazars.us/forsights/2024/03/how-to-set-up-data-exchange-definitions-in-business-central

https://www.youtube.com/watch?v=yEF7dBq5Nq0

https://www.youtube.com/watch?v=HX_K1EpsoVs

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,169 Most Valuable Professional on at

Like (1)

Report

Hi

You could also look into some third-party solutions if your requirement warrants it. I hope this helps. Find the right app | Microsoft AppSource

Best

GR

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (0)

Report

You need to get a sample EFT file from the bank either yourself or through the customer. Bank usually doesn't communicate with a partner.

You also need to get the EFT specification file from the bank, which is usually lengthy. You need to find out from the 2 files what are the mandatory data to be mapped. BC has a few sample EFT data exchange definition for reference.

Another easy way is to use an addon from 3rd party, it costs the subscription fee. The 3rd party normally support all formats for the banks.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

What specific challenges are you facing?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, If the standard setup doesn't do the trick, you can consider some simple customizations.

More details:

Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization

https://yzhums.com/44582/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No