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

Issue while setting Currency Exchange Rate Service

(0) Share

Report

Posted on by Bhagyashree Shahade

170

I am trying to set up Currency Exchange Rate Service https://openexchangerates.org/. My local currency is BRL and I need in USD. The response is in XML. However, when I Preview it, currency Exchange Rate shows empty window.

Am I going wrong anywhere in Field Mapping?Plz Help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

@Bhagyashree Shahade

Hi

Can you please copy the first image that shows the setting again. it is small and setup are not visible.

Also, as an extra info you have the following options

Below is the free app that uses openrates.io to populate the rate

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

Or go through floatrate guideline and check your setup

https://www.innovia.com/blog/how-automate-currency-exchange-rate-updates-business-central-nav

https://yzhums.com/7341/

I hope this help

Was this reply helpful? Yes No
Bhagyashree Shahade 170 on at

Like (0)

Report

Hi Mahgah,

Please find the copy of 1st Image Below:

Was this reply helpful? Yes No
Bhagyashree Shahade 170 on at

Like (0)

Report

Also, since we already have a purchased service of OpenExchange , hence we are not using others one

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

I use FloatRate so the process is the same the URL is different. I am attaching my instructions I give my customers that will help you here.

Thanks,

Steve

6254.FloatRate-Setup.docx

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi

Thanks

I could not see anything wrong in your setup but I am not familiar with this service. Maybe others can provide more info. But for now can you please test and remove USD from the end maybe that help. I mean in other setup I can see that no currency identified here. Hence, maybe you should not use USD and only stay with the first section of it.

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hello,

The only thing I can guess at, and I too do not use this service, is your setup points to ROOT and my FloatRate points to Channel. Maybe you can update this and test.

Thanks,

Steve

Was this reply helpful? Yes No
Bhagyashree Shahade 170 on at

Like (0)

Report

Hi,

Thanks Steve & Mahgah for the response,

I got the Mappings working!

Can you guys help me on how can I get historical rates because now I can see only rate of startdate (say 10th August )and not all the rates above 10th August till now/enddate, though I have queried the Service on Start Date and Enddate. Am I missing anything?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi

I know I did it by downloading history cvs file and then uploading to the following table. But I am sure someone has a better method.

Currency Exchange Rate (330)

Was this reply helpful? Yes No