Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Shari Bruno]

?Good Morning!

For those who are multi-currency, do you use exchange rate feed software to populate rates in your currency tables? If so, what software do you use, and where are they getting the rates?

We use Olympic and got rates through ComFex for several years, but switched to Yahoo about a year ago. Unfortunately Yahoo stopped working, and the alternatives provided to us by Olympic don’t meet our needs due to our large number of exotic currencies and currency pairs.

Any and all information is greatly appreciated.
Thanks!

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————

[Windi Epperson]

Hey
Check out http://envisagesoftware.com/exchange-rate-feed-for-dynamics-gp/
We looked at this for a customer recently and we were really happy with the pricing and it can import from several different services.
Thanks
Windi?

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 ext. 102
——————————
——————————————-

[Silver Subie]

I implemented this solution 5-6 years back. We only had 5-6 different currencies and it worked well.  If you accept Google Finance feed, it should work for you.  I can’t remember how many different feeds they have, at least 3 at the time I used.  Check w them.  

https://www.expsoltech.com/downloads/GP_MC/GP%20Xchange%20Rate%20Feeder_User%20Manual.pdf

Expsoltech		remove preview
View this on Expsoltech >

——————————————-

[Shari Bruno]

?Thanks and !

Our partner mentioned Envisage and I will check into Expsoltech too.

A question for the two of you, are you valuing exotic currencies? The majority of the 46 currencies we need to value are exotic, mostly from Africa and SE Asia. ?Our biggest roadblock has been finding a service that can provide those rates.

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Silver Subie]

No, only CAD, pounds and Middle East currencies.

I do remember the software itself is flexible where you could define/add the feed; Or, ask them to change/add the feed for you. I thought we were using Oanda feed back then but couldn’t remember.  I need to take it easy on single malt ;-)——————————————-

[Shari Bruno]

I need to take it easy on single malt 😉

Silver Subie,  08-15-2018 01:50 PM

At least during the workday   🙂

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Kim Peterson]

I’m most familiar with Olympic Systems.

But MVP Mohammad has written one that could help you.

• Written by Mohammad R. Daoud a Dynamics GP MVP
• Incredibly small footprint
• Downloads exchange rates according to your schedule
• Automatically updates GP Exchange tables
•  

• mohdaoud.blogspot.com  (Blog)

  dynamicsinnovations.com  (Company Website)

  mohdaoud.blogspot.com/feeds/posts/default  (RSS Feed)

——————————
Kim Peterson
218-862-5002
Kim@DynamicsConnections.com
#KimPetersonGP
——————————
——————————————-

[Maria Frandzeskakis]

Hi ,

We’re also using Olympic, with the Bank of Canada rate feed.

This is the link in case it helps:
Daily Exchange Rates

Kind regards,

?

——————————
Maria Frandzeskakis
IT Manager
MIP Inc.
Anjou QC
——————————
——————————————-

[Shari Bruno]

?Thanks , I will look into Bank of Canada as well.?

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Windi Epperson]

Not sure about exotic rates, but the info I have from envisage says:
Exchange rates can be sourced from a number of free currency web service sites. Alternatively, you can connect the application to a paid subscription web service like http://www.xe.com/ or http://www.oanda.com/  

I looked at those two sites and they have on-website-converters that have a ton of rates so maybe that will give you a glimpse into what rates they facilitate.
Thanks
Windi?

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 ext. 102
——————————
——————————————-

[Andrew Dean]

Hi Shari

The Exchange Rate Feed from Envisage can connect to the following free currency services

–  http://api.openrates.io/latest?base={0}
–  http://free.currencyconverterapi.com/api/v3/convert?q={0}_{1}&compact=y
–  http://www.bankofcanada.ca/valet/fx_rss/FX{0}CAD

Note: in the URL examples,  replace {X} values with relevant ISO currency code.

There are two subscription sites the application can connect to (www.oanda.com and http://www.xe.com) but these have expensive monthly subscription fees.

Some new currency subscription sites are now coming online that convert all currencies and are reasonably priced.  ( ie.  https://fixer.io/product ) 

Hope this information helps.

——————————
Andrew Dean
Envisage Software

——————————
——————————————-

[David Morinello]

?Also, some banks will provide this data to you free of charge, if you ask. I have an FTP job pull a small text file from BOA nightly and consume it using SmartConnect into GP.  169 different country currencies, although we only use GBP at the moment.

When you have a hammer (SmartConnect), everything starts to look like a Nail.

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————
——————————————-

[Shari Bruno]

?Wow! Thank you everyone, so much great information to check into. I appreciate all of your expertise!!

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-