How to Update Currency Exchange Rate (table) automatically?

Aravindh_Navision

Hi Friends,

I need to update currency exchange rate (table) value automatically on daily basis. I have come across few related topics, but I have few clarifications to be made.

1. What are all the different types of solutions available for achieving this?
2. If I am doing using Webservices, does I need to upgrade my current license or it is readily available?
3. Does I need to upgrade my license to access Job Queue objects?

Please share me the link which is related to automatic updation of Currency exchange rate.

Thanks,
Aravindh

vinkomalada

Hi,

there are several ways to this, I can tell you the method that works for us. We are using the script that can download exchange rates as .txt files on the network share. The script is called from codeunit in NAV that reads those .txt files and fills the exchange rates table in NAV. This codeunit is then normally schedulled as a job in NAV and executed by application server.

For the development of this codeunit you need partner's licence of course, but for the execution the customer's licence is enough provided the codeunit is in the customer's licence range.

Best regards,

Vinko Malada

Aravindh_Navision

Thanks vinkomalada for your reply.

Could you please share, how to do it? From where you are downloading the .txt files? Are you downloading from any website?


Regards,
Aravindh.

vinkomalada

Hello,

we download it from the web site of the national bank of Croatia. Usually banks publish currency rate lists in a convenient format that can be downloaded as a .txt or .csv file. You can then read from that file and import data into NAV.

Vinko

Aravindh_Navision

Is there anyother approach available to achieve this?

Thanks,
Aravindh