It’s a common task for every organization to import currency exchange rates on the daily schedule.
In NAV2017 for this task, we can use Currency exchange rate service.
If we look at standard Cronus database we can find default Yahoo service. However, it doesn’t work for Russian localization.
What to do?
In Russia, we import everyday currency rates, from central bank site. (I think the same is for other countries).
Here is link: http://www.cbr.ru/scripts/XML_daily.asp
(There is also additional services from Russian central bank)
Next what we need is to set up this service in NAV2017RU
How to setup in NAV?
1. Open NAV. Search for “Currency Exchange Rate Service”
2. Click New
3. Fill header like in the screenshot
4. Go to Field Mapping tab and Click on Source in each line. If you inputted correct Service URL in the previous step, then you will get an example of an XML file.
Choose a line and click ok.
You should setup Field Mapping like in the next screenshot.
Click Edit and fill Default Value on Exchange Rate Amount with 1.
Next step is my favorite 🙂
5. Create Transformation Rules.
Microsoft didn’t prepare for us Russian transformation rules. There are some on the Russian language, but with Dutch setups inside. Microsoft loves Dutch setups, history… I understand 🙂
So we need to create 2 transformation rules: for date fields and for decimal fields.
Go to Start date line and assist in Transformation Rule field. Click New
Fill page and click OK
Make the same for Exchange rate amount line
So, in the end, you should have next Field mapping setup
Click on Preview button. You will see Russian Exchange rates preview page, just downloaded from Russian Central Bank.
Click on Enabled field on the General tab. Nav will create Job queue entry to check Exchange rates on daily basis.
Now your financials team can sleep a bit more 🙂