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

Notifications

Announcements

No record found.

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 416

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 133 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 416 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 133 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 416 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 133 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 416 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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans