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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Issue while setting Currency Exchange Rate Service

(0) ShareShare
ReportReport
Posted on by 170

Hi

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

pastedimage1629729574779v3.pngScreenshot-_2800_442_2900_.pngScreenshot-_2800_443_2900_.png

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at
    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 

  • Bhagyashree Shahade Profile Picture
    170 on at
    RE: Issue while setting Currency Exchange Rate Service

    Hi Mahgah,

    Please find the copy of 1st Image Below:

    5824.picture.PNG

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

    5355.picture.PNG

  • Suggested answer
    Community Member Profile Picture
    on at
    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

  • Suggested answer
    MahGah Profile Picture
    15,529 on at
    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 

    pastedimage1629743333569v1.png

  • Suggested answer
    Community Member Profile Picture
    on at
    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.

    pastedimage1629746959189v1.png

    Thanks,

    Steve

  • Bhagyashree Shahade Profile Picture
    170 on at
    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
    MahGah Profile Picture
    15,529 on at
    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)

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,762

#2
Sumit Singh Profile Picture

Sumit Singh 2,573

#3
YUN ZHU Profile Picture

YUN ZHU 1,930 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans