Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Issue while setting Currency Exchange Rate Service

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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,409 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)
  • 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 Profile Picture
    Community Member Microsoft Employee 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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,409 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
    Community Member Microsoft Employee 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

  • 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

  • RE: Issue while setting Currency Exchange Rate Service

    Hi Mahgah,

    Please find the copy of 1st Image Below:

    5824.picture.PNG

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans