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

DATA EXCHANGE DEFINITION FOR BMO BANK USA

(1) Share

Report

Posted on by DynamicsBC

302

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)

Sort by

Suggested answer

Khushbu Rajvi. 22,551 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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... 27,054 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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,220 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 32,755 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 101,787 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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