Automatic Updating of Exchange Rates

(0) Share

Report

Posted on by john.ellis

3,530

Hi:

In one sandbox, I did my best to configure automatic daily updating of exchange rates. Prior to this, we had an exchange rate dated 01/01/2022.

When I ran Update Exchange Rates, it added another rate dated 01/31/2022. Why not daily rates for every day since 01/31/2022?

And, in another sandbox, it's not going even that well. Despite the log for the Job Queue Entry displaying "Success", I see no updated exchange rates -- daily or otherwise. Of course, I did try a free exchange rate update extension. I could not figure it out. So, I uninstalled it. Perhaps, doing all of that messed up the daily exchange rate job queue that I created.

I have read all of the documentation and tutorials on this subject to no avail.

How, easily and succinctly, can I simply perform automated daily updates of exchange rates and where the Local Currency is CAD (Canadian)?

Thanks!

John

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

Hi John

For CAD you have a better option than floatrates (usual site that most people use). You can use Bank of Canada. See the guideline below. Specially video that can provide better details.

https://www.encorebusiness.com/blog/free-exchange-rates-dynamics-nav-business-central

In this guideline as mentioned in guideline you can change the 2018-07-01 date to any date that you want to start and then it will build the history from that date. I hope this help.

http://www.bankofcanada.ca/valet/observations/group/FX_RATES_DAILY/xml?start_date=2018-07-01

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,908 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following will also help.

https://yzhums.com/7341/

PS:

When you complete the setup, a Job Queue that runs daily will be automatically created, and you can view its running history in Job Queue Log Entries page.

Of course you can also run it manually every day.

Hope this info will help.

Thanks.

ZHU

Was this reply helpful? Yes No