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

All responses (8)

Answers (0)

Suggested answer

MahGah 15,435 on at

Like (1)

Report

RE: Issue while setting Currency Exchange Rate Service

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)
Bhagyashree Shahade 170 on at

Like (0)

Report

RE: Issue while setting Currency Exchange Rate Service

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?
Suggested answer

Community Member on at

Like (1)

Report

RE: Issue while setting Currency Exchange Rate Service

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
Suggested answer

MahGah 15,435 on at

Like (1)

Report

RE: Issue while setting Currency Exchange Rate Service

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
Suggested answer

Community Member on at

Like (0)

Report

RE: Issue while setting Currency Exchange Rate Service

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
Bhagyashree Shahade 170 on at

Like (0)

Report

RE: Issue while setting Currency Exchange Rate Service

Also, since we already have a purchased service of OpenExchange , hence we are not using others one
Bhagyashree Shahade 170 on at

Like (0)

Report

RE: Issue while setting Currency Exchange Rate Service

Hi Mahgah,

Please find the copy of 1st Image Below:
Suggested answer

MahGah 15,435 on at

Like (0)

Report

RE: Issue while setting Currency Exchange Rate Service

@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