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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Currency exchange rate...
Small and medium business | Business Central, N...
Suggested Answer

Currency exchange rates services for UK and DE

(0) ShareShare
ReportReport
Posted on by AntonioKD 432

Hello ! 

I have a question. I want to set up currency exchange rate service for my companies in UK and Germany. Which bank supports this service in the UK and which in DE? I only found information about the ECB, but I don't know if it is preferred for these countries. Could I have some materials that I could follow when setting this up?

Thank you in advance! 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    First consideration being what FX rate site do the accountants in those companies currently follow? Do they have a web service? If so try and set it up to use that. If they don’t mind which FX site you could try this free one: https://yzhums.com/7341/

  • AntonioKD Profile Picture
    AntonioKD 432 on at

    Thank you Josh!

    But do you know if it is possible to connect Business Central with HMRC (www.gov.uk/.../hmrc-exchange-rates-for-2021-monthly) as a currency exchange rate service for UK?

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    HMRC has two choices. CSV or XML. It's a URL per month in terms of the XML option: www.hmrc.gov.uk/.../2021-exrates.html

    That seems like an acceptable avenue. Altering the URL to be correct each month will probably need some development - URL for data is like this: www.hmrc.gov.uk/.../exrates-monthly-0721.XML

  • AntonioKD Profile Picture
    AntonioKD 432 on at

    OK, thank you! Do you have any instruction how to set up the Currency exchange rate service from HMRC?

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    The original link I provided has some similarities. Still use the exchange rate service setup. Eventually you get a data exchange definition created. Add a dummy value until you do. Download a xml file of the hmrc data. Go to the data exchange definition and locate a “get file structure” and choose the xml file. That will insert all the fields. You can then choose the ones that need to be passed into BC with the field mapping section

  • AntonioKD Profile Picture
    AntonioKD 432 on at

    And do you know the possibilities of connecting with the currency exchange service from Bank Of England? www.bankofengland.co.uk/.../Rates.asp

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 589 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 453 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 328 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans