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

Currency exchange rates services for UK - Bank of England

(0) Share

Report

Posted on by AntonioKD

416

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!

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

JAngle 133 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
AntonioKD 416 on at

Like (0)

Report

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 :)

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

David,

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

Thanks,

Steve

Was this reply helpful? Yes No
AntonioKD 416 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No