Auto currency exchange rate update Nav 2009 R2

  • Auto currency exchange rate update Nav 2009 R2

    Posted by DSC Communities on December 30, 2016 at 12:51 pm
    • Austin Schuerg


      December 30, 2016 at 12:51 PM


      We have begun invoicing customers in a foreign currency to ease their payment process.  In doing so, we have been updating the exchange rate on a regular basis in order to calculate the invoices accurately.  We are aware that Nav 2016 has the ability to automatically update exchange rates and we will eventually be migrating to that version in the upcoming year from our current 2009 R2.  In the meantime, we were hoping there was a way to automatically update exchange rates now so that it is not a daily requirement.  Does anyone have any experience/knowledge on whether it is possible and if so, how?

      Thank you in advance!

      Austin Schuerg
      Simms Fishing Products
      Bozeman MT

    • Matt Traxinger


      December 30, 2016 at 2:50 PM

      It is not possible to do it out of the box. You would have to do a customization. Most companies that I am aware of don’t update the rates every day. I usually see it done ever week or every month.

      Matt Traxinger
      NAV Developer
      ArcherPoint Inc.
      San Antonio TX

    • Mary Ann Bordes


      January 2, 2017 at 8:09 AM


      If you are thinking about a customization, consider this. 

      We update rates daily via a web services connection using a customization that pulls rates from Oanda.  If the bank website is down the process fails the service stops and has to be restarted. (Programming?)  We are then required to manual update rates for each day missed.  We now have a jet report the is scheduled and runs right after the currency update to confirm a successful run. This ensures we have no more than one day’s data to update in the event of an outage.

      Best up luck! 

      PS. You may have to adjust some of your posting groups in various places in the system to utilize the rounding features.

      Mary Ann Bordes
      ERP Accounting Systems Manager
      Houston TX

    • David Machanick


      January 2, 2017 at 4:00 PM

      Since you are upgrading, why not go to NAV 2017? The level of effort is about the same and you will get all of the new features.

      David Machanick
      Sikich LLP
      Garland TX

    DSC Communities replied 7 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Auto currency exchange rate update Nav 2009 R2’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!