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?
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
Member
January 2, 2017 at 8:09 AM
Hi!
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 TGS Houston TX ————————————————————————-
David Machanick
Member
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 ————————————————————————-
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
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!