BC SaaS: Currency Exchange Rate Service for New Zealand

(0) Share

Report

Posted on by Samantha73

3,297

Hi All,

For Australia I use "https://www.rba.gov.au/rss/rss-cb-exchange-rates.xml" to configure exchange rate service in BC SaaS. Is there a URL for RBNZ? or any other alternatives?

Thanks

I have the same question (0)

All responses (14)

Answers (2)

Suggested answer

Franziska Fiegler Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Samantha,

Basically you just need a XML feed which gives you the needed information and you can map it in the setup for the currency exchange rate service.

As an example http://www.floatrates.com/feeds.html offers a number of feeds with a different base currency. With this feed http://www.floatrates.com/daily/sgd.xml you will get the currency rates based on Singapore Dollars and with this one http://www.floatrates.com/daily/eur.xml a feed with EUR as base. The first URL gives you an overview of all available currencies.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Great, but how do I inverse/invert the exchange rates?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,581 on at

Like (0)

Report
Copy link

Link copied!

Also, it is free app by Erik Hougaard available for SaaS version.

appsource.microsoft.com/.../PUBID.hougaard-4699382|AID.openrates|PAPPID.362079c8-83e6-48cb-9099-7c19886bfcfa

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Great, but how do I inverse/invert the exchange rates (onprem version)?

Was this reply helpful? Yes No
Samantha73 3,297 on at

Like (0)

Report
Copy link

Link copied!

You need to set the last column on currency rate page - I think its called relation currency in drop down. first test it setting manually and after set it in the mapping

Was this reply helpful? Yes No
Franziska Fiegler Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Create a new Currency exchange rate setup and add the feed in the Service URL field.

Later add the field mapping be selecting the source for all the fields. If needed add a transformation rule for the date.

.
.
.

Another example is the service provided by the ECB (European Central Bank) - for EUR

http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Samantha,

I have worked with FloatRate for all my customers anywhere. It works perfectly and runs on the Job Queue service to update each morning. Here is my implementation instructions.

Thanks,

Steve

5468.FloatRate-Setup.docx

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,242 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following will help.

https://yzhums.com/7341/

Thanks.

ZHU

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Zhu

If the currency exchange service is enabled and greyed out, how do I make a change to select the inverse rate?

Thanks

Peter

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

First, uncheck the enable box in the General tab. Then try the setup in the Field mapping, screenshot below.

Was this reply helpful? Yes No