ArcherPoint Dynamics NAV Developer Digest - vol 173
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Suresh asks the question and shares Freddy’s answer in his blog post.
Bill W. wasn’t successful the first time and replies “Huh, I'll have to try again, I was getting errors trying do a 2015 container.”
Suresh: Try the latest CU or above CU 7.
Bill: I was doing CU 16 and then the latest. Had to isolate an issue with the latest CU so this was a total pain to have to install into a new VM. Have you done this successfully?
Suresh: Yes, but I had trouble with RTC needed to troubleshoot. Dev client and webclient are working fine. You need to make sure you have generic image downloaded.
I even got RTC working when I use the container IP address, I might have to update my host file to use the name.
Bill: Tried again, I had to unblock the zip file before I extracted it.
Updating Currency Using Currency Exchange Rate Web Service
Roger asks, “I’m looking for information on Updating Currency using the Currency Exchange Rate Service. It looks like NAV introduced this in 2016. Does anyone have any experience with it?”
Alan L responds, “It appears that YAHOO no longer offers a free service for the currency updates. As a result Microsoft found another service: Float Rate.
Attached is a RAPIDSTart package and Instructions to set this up in a 2017 database. I have tested this in a test environment, and it seems to work well.”
Helle shared a RapidStart package that creates a Currency Exchange Rate Service called FLOATRATES and a Data Exchange Definition called CURRENCY0002. She wasn’t sure why, but it also creates CURRENCY0003 and links that one to FLOATRATES. In order to correct, "Data Exch. Def Code" field in Curr. Exch. Rate Update Setup must be updated accordingly (i.e. CURRENCY0002 instead of CURRENCY0003). FYI, the field is not on the card by default.
Another "interesting snafu": TryFunction works differently in NAV2017 vs. in NAV2016. The way currency exchange rates now get updated with FloatRates (because the URL returns all currency codes vs. Yahoo Finance, where the URL only returned values for the currency codes in the company), it is necessary to use codeunit 1280 Map Currency Exchange Rate from NAV2017 if you're using NAV2017 executables.
Apparently, there's also a parameter on the service that can be changed from its default value, so TryFunction will work in "2016 mode." I did not try to change that.”
Stay abreast of what is new in the Microsoft Dynamics NAV community and at ArcherPoint by subscribing to our monthly newsletter, Better Business, by completing the form in our Resource Center.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.