Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Paul Silvani]

We are setting up the Currency Exchange Rate Service in NAV to allow us to get the daily exchange rates and bring into NAV.  In the past, it appears that Yahoo was the main engine that everyone was using but now Yahoo has discontinued that service.

Does anyone have any recommendations for services (either free or for a fee) that they would recommend for connecting to NAV and getting the daily exchange rates?

Thanks!

——————————
Paul Silvani
General Manager
Velosio
Chicago IL
——————————

[Eduardo Diaz]

It is unfortunately that Yahoo discontinued their Currency Exchange Rate Services. Microsoft should offer one instead. The only third party solution that I found is Integrating Dynamics NAV and Exchange Rates automatically

Dynamicsnavaddons		remove preview
Integrating Dynamics NAV and Exchange Rates automatically Learn how to automate the function of updating and managing foreign currency exchange rates-especially with multiple companies-within Microsoft Dynamics NAV View this on Dynamicsnavaddons >

——————————
Eduardo Diaz
IT Director
Minequip Corp.
Palmetto Bay FL
——————————
——————————————-

[Ramin Marghi]

Hi Paul,

You can pretty much get any forex feed service into NAV with enough elbow grease and Ibuprofen (heh). These feeds can be open ones or paid ones where you need an app ID/authentication key to access the API, etc. I have a post about the Bank of Canada here but since you’re in the US this might only help anecdotally: Exchange Excellence, Eh? Connecting Dynamics 365 for Financials and NAV 2017 Currency Exchange Rate Services to the Bank of Canada – Catapult ERP 

For simplicity’s sake, I’ll go over an example of a free XML feed. Yes you can technically hook up to a JSON feed, but my pain tolerance this morning is somewhere in the ‘nope’ region. Here’s an example of how to get FloatRates.com’s daily USD rates XML feed into NAV:

1) Find the Feed: I went onto FloatRates.com and found the link to the .XML feed for the daily USD:

2) Create a New Service in NAV: I opened up NAV, went to the Currency Exchange Rate Services page and created a new one called FLOATRATES and pasted in the feed into the Service URL:

3) Map the Fields: I used the nifty AssistEdit buttons in the “Field Mapping” FastTab to pick the appropriate fields for my mapping:

4) Deal with the Dates: Dates are annoying since this feed uses a format that looks like “Thu, 10 May 2018 12:00:01 GMT”. Gah. So what I did is created a new Transformation Rule called “FLOATRATESDATE” (kinda rhymes) and did something like this:

Few notes on this: the “Starting Text” is a space, not blank. And the “Ending Text” is a space followed by ” GMT” so that it snips off that stuff. Also, make sure you have a Next Transformation Rule that reformats the date into the US date format.

5) Preview and Confirm: Simply click the Preview button on this new service and revel in the glory of NAV’s beautiful data exchange engine:

Hope that helps!

——————————
Ramin Marghi , CPA, CGA
CPA, CGA | ERP Consultant
Catapult
VANCOUVER BC
——————————
——————————————-

[Jeffrey Mantz]

Float Rates is what we setup, and did have a couple of quirks getting it going. I found a website where someone posted a RapidStart package with the entire setup. Scroll to the end of the article for the package.

Who ever made this has really done a nice job in helping all NAV users who have had problems with this. I tested the package myself and it works perfectly.

Setup Free Currency Exchange Rate Service Feed for NAV : Open Door Technology

——————————
Jeffrey Mantz
Zefon International
——————————
——————————————-

[Matt Dusenberry]

?Great document to provide a step by step.

One question hoping you can help with.

Working in #NAV2017 and when I click preview after importing package it takes me to my Currency Exchange Rates table. Nothing is there and when I try to add a currency code (I believe this should auto populate?) nothing happens. It gives me an error that it’s missing but it’s a selection option. Anyone else seen this issue? Image attached for reference. If I try to select it it will not stick when added.
?

——————————
Matt Dusenberry
Group O
Milan IL
——————————
——————————————-

[Samuel Champoux]

?I used this guide to connect to Bank of Canada’s feed and it works very well.

https://www.catapulterp.com/dynamics-365-financials-nav-2017-currency-exchange-rate-services/

——————————
Samuel Champoux
IT Director
Drummondville QC Canada
——————————
——————————————-

[Jimmy Yu]

When you hit Preview and the Currency Exchange Rate table is blank, then it means you’re not properly configured.

The Exchange Rate Services is definitely not easy to setup.  The problem I consistently struggle with is the timing of the retrieval.  I’m not quite sure how to configure this but when my Job Queue is set for 10pm Mountain Time, the rate retrieved is for the next day and not the current day.  This is due to the NAV SQL server being set to GMT (currently +7 hrs compared to MST).  I know the answer will be to tell NAV to grab a specific date and set to (today-1).  But that may have to be done in the codeunit, which means I would need a developer.

——————————
Jimmy Yu
Step Energy Services Inc
Calgary AB
——————————
——————————————-