BC SaaS: Currency Exchange Rate Service for New Zealand

(0) Share

Report

Posted on by Samantha73

3,255

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 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

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

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

Like (0)

Report

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 on at

Like (0)

Report

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

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 95,720 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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