Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 - Bank of England

(0) ShareShare
ReportReport
Posted on by AntonioKD 315

Hello everyone! 

Do you know if it is possible to connect Business Central with a Bank Of Englad (https://www.bankofengland.co.uk/boeapps/database/Rates.asp?TD=23&TM=Jul&TY=2021&into=GBP&rateview=D) in order to download exchange rates? If yes, do you have any instruction how to do it?

Thank you in advance! 

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Currency exchange rates services for UK - Bank of England

    Hi

    In my opinion, in general most rate from exchange rate services all close to each other. But central bank rate are more official. 

    If you like to use ECB as a source to be more official then you can 

    1) Follow this tread info/guideline: community.dynamics.com/.../1096202

    2) or use this app: https://www.eos-solutions.it/en/historical-ecb-exchange-rates-en.html

    I hope this help 

  • AntonioKD Profile Picture
    AntonioKD 315 on at
    RE: Currency exchange rates services for UK - Bank of England

    Thank you, I have delved into the subject and will try to convince the team to FloatRates.

    I have one more question. In Germany, the most common currency rate service is from ECB (European Central Bank) ? Or maybe also FLoatRates?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Currency exchange rates services for UK - Bank of England

    David,

    Josh replied back on your question and MahGah added more information.

    Thanks,

    Steve

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Currency exchange rates services for UK - Bank of England

    Hi David

    I know you asked specifically about the url you mentioned. Josh and Steve provided extra info. In addition, you can see the following

    This is sort of a general guideline to connect to any url if all conditions meet. 

    https://www.catapulterp.com/our-resources/exchange-excellence-eh-connecting-nav-2017-and-business-central-currency-exchange-rate-services-to-the-bank-of-canada/

    Or if you are on SaaS this is a new free app

    https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.hougaard-4699382%7CAID.openrates%7CPAPPID.362079c8-83e6-48cb-9099-7c19886bfcfa?tab=Overview

    Thanks 

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Currency exchange rates services for UK - Bank of England

    Float rates is common because it is free and many have done instructions on how to configure it. If you can convince the accounts team to switch fx provider then it’s a winner

  • AntonioKD Profile Picture
    AntonioKD 315 on at
    RE: Currency exchange rates services for UK - Bank of England

    OMG thank you so much Steven for your instruction!

    And one more quetsion - in United Kingdom it is common to use Float Rates to download currency exchange? I want to propose this to the client, but they say that they use for income tax monthly rate currency exchange from HMRC and for valuation Bank of England :)

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Currency exchange rates services for UK - Bank of England

    David,

    Adding to what Josh replied... I have used Float Rates to download my currency exchange. Here is a instructional handout to implement.

    Thanks,

    Steve

    FloatRate-Setup.docx

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Currency exchange rates services for UK - Bank of England

    If you use that url to get data in excel do you get a result? Similar if you use it in a http client like postman? You’ll stand a chance if yes.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans