Configuration

Previous  Next |  Direct link to this topic

Go to the configuration of the online exchange rates located in Administration > Add-ons > B1 Usability Package > Module Configurations > Currency Rates: Configuration

image106

Field

Description

Source

Here you indicate the source from where you would like to get your exchange rates. Currently the following are supported:

Source

URL

European Central Bank (EBC)

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

National Bank of Denmark

http://www.nationalbanken.dk/_vti_bin/DN/DataService.svc/CurrencyRatesXML?lang=da

Bank Of Israel

https://www.boi.org.il/currency.xml

Westpac (NZ)

http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml

Bank of Canada

http://www.bankofcanada.ca/valet/fx_rss/

Czech National Bank

http://www.cnb.cz/cs/financni_trhy/devizovy_trh/kurzy _devizoveho_trhu/denni_kurz.txt

Nordea

https://www.nordea.com/wemapp/api/fi/lists/currency/electronicExchangeFI.dat

Reserve Bank Of Australia

http://www.rba.gov.au/rss/rss-cb-exchange-rates.xml

Federal Tax administration (Switzerland)

http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php

Oanda (Bid/Ask/Midpoint)

http://www.oanda.com

NB: THIS REQUIRES AN ACTIVE SUBSCRIPTION FOR OANDA CSV RATES

Banco De México

http://www.banxico.org.mx/rsscb/rss?BMXC_canal=pagos&BMXC_idioma=es (USD)

+

http://www.banxico.org.mx/rsscb/rss?BMXC_canal=euro&BMXC_idioma=es (EUR)

Banco De Guatemala

http://www.banguat.gob.gt/variables/ws/TipoCambio.asmx?op=TipoCambioDia

Central Bank of Russia

http://www.cbr.ru/scripts/XML_daily.asp

Bank of Brazil

http://www4.bcb.gov.br/Download/fechamento/20141207.csv (where last part being the date of the rate in yyyyMMdd (above 7th of December 2014))

National Bank of Poland

http://www.nbp.pl/kursy/xml/LastA.xml

HM Revenue & Customs (UK) [Monthly]

http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0615.xml (where last part being the month/year of the rate in MMyy (example = June of 2015))

Monetary Authority Of Singapore

https://secure.mas.gov.sg/msb/Feeds.aspx

Banco central de Costa Rica

http://indicadoreseconomicos.bccr.fi.cr/indicadoreseconomicos/WebServices/wsIndicadoresEconomicos.asmx/ObtenerIndicadoresEconomicosXML?tcIndicador=317&tcFechaInicio=29/06/2017&tcFechaFinal=29/06/2017&tcNombre=Boyum&tnSubNiveles=N

where:

tcFechaInicio = start date you want rates for

tcFechaFinal = end date you want rates for

tcNombre = any name

 

Banco central de Chile

Webservice (http://si3.bcentral.cl/estadisticas/Principal1/Web_Services/index.htm)

Rounding decimals *

The online sources typically have exchange rates with 4 decimals, but you can lower this if you like.

 

NB: This feature is not used when using online service scheduling option, due to low usage, if you think it should be part of the online service functionality, contact support@boyum-it.com and tell us why you want this feature together with online services

Interval of check

Here you decide if the exchange rates should be imported one month at the time or just one day at the time.

Fill indicated days back if missing

Here you have the option to backtrack the exchange rates if previous days are missing (Weekend and days where add-on was not started). [NB. Please do not set this to high, since it will lower performance].

Warn if deviation from last rate is above % *

Here you can enter a warning system if exchange rates deviate too much. You can set the number of percentage that the rates can deviate without warnings.

NB: This feature is not used when using online service scheduling option, due to low usage, if you think it should be part of the online service functionality, contact support@boyum-it.com and tell us why you want this feature together with online services

Additional Fee: Direct *

If you wish to make the exchange rate fee higher than the online source you have the option to add a fixed amount to the rate (Example if currency XXX is 5.5 and Fee is 1.0 the value set in SAP will be 6.5)

NB: BE VERY AWARE OF T THIS OPTION IF YOU IMPORT MORE THAN ONE CURRENCY SINCE THIS IS A FIXED FEE IN LOCAL CURRENCY

 

NB: This feature is not used when using online service scheduling option, due to low usage, if you think it should be part of the online service functionality, contact support@boyum-it.com and tell us why you want this feature together with online services

Additional Fee: Percentage *

This fee is like the direct fee added onto of the online value but as a percentage instead.

NB: IF YOU USE BOTH THE DIRECT FEE AND THE PERCENTAGE FEE, THE DIRECT FEE WILL BE ADDED FIRST BEFORE THE PERCENTAGE FEE IS ADDED

 

NB: This feature is not used when using online service scheduling option, due to low usage, if you think it should be part of the online service functionality, contact support@boyum-it.com and tell us why you want this feature together with online services

Days Set in the Future

Here you can set number of days you want to take todays rate and pass it into the future. This is handy if you need exchange rates in the weekend days but does not login during the weekend.

 

 

 

Scheduling setup

Field

Description

Schedule Option

if selected scheduling option is other than no scheduling, the selected scheduling option will update exchange rates based on the interval defined.

 

the possible scheduling options are:

No scheduling

Server component (requires that the server component has been installed and configured).

Online services - HANA only (cloud based and requires service layer)

 

Success email

If set an email will be send when the exchange rates are updated (Optional).

Error email

If an error occurs and email will be send to this email.

Server run time (24 H/M)

The fields controls at what time of the day the import of exchange rates happens on the server.

Server day in the month to run (If monthly interval is selected)

This field determines what day of the month the import of exchange rates should take place (Only when Monthly interval of check is selected).

Always update exchange rates even if filled

Force the server component to always update the exchange rates even if already filled.

Do not set rates on user login (Only Server component)

If you enable this option, the add-on itself will never set the rates. Do this if you want to have the Server component to be the only trigger of new rates.

DATABASES THAT DO NOT FOLLOW THE ISO STANDARDS CAN USE THE CURRENCY WINDOW TO DEFINE WHAT THEIR CURRENCY SYMBOL RELATES TO IN THE CURRENCY DEFINITION WINDOW (ADMINISTRATION > SETUP > FINANCIALS > CURRENCIES).

The order of how the currency code determined is as follows:

-         First ISO Currency Code is check and use if filled

-         If no ISO Code, then we try the B1UP ISO Extender column and use if filled

-         If neither ISO and B1UP ISO is filled Code is tried use

Should none of the above be correct the import will fail and you will get an error message that you should setup the codes. In that case set the ISO Currency code for faster performance.

image107