How do currency conversion rates work? How can I upload currency conversion rates into Ariba?

	English	
Deutsch - Machine Translation Español - Machine Translation Français (France) - Machine Translation Italiano - Machine Translation 日本語 - Machine Translation 한국어 - Machine Translation Português (Brasil) - Machine Translation Русский - Machine Translation 简体中文 - Machine Translation

FAQ KB0394196

Symptom

Procedure to import the currency conversion rates.

Resolution

Currency conversion rate is defined in a Microsoft^® Excel or comma-separated value (CSV) file that you can export through the Data Import/Export task:

For sourcing only realm, you can export the file by going to:

Manage > Administration > Site Manager > Data Import/Export > Export tab > search for Export Currency Conversion Rates.

For integrated realm/integrated suite, it appears in:

Manage > Core Administration > Site Manager > Data Import/Export > Export tab > search for Export Currency Conversion Rates.

For integrated sites, everything defined in this file also appears in the sourcing part (Manage >Administration). If the Application.AQS.EnableCurrencyConversionRateSetSync paramter is enabled and if user import the currency exchange rates, then it will appear in both upstream and downstream and viceversa.

File consists of five columns:

FromCurrency: defines the currency from which we will make the conversion.
ToCurrency: defines the currency into which we will convert the value.
Rate: the rate that system will use to convert.
UniqueName: (not mandatory column) used when you want to overwrite the existing conversion rate in operational procurement. If you are importing new rates, you can leave it blank. In upstream/sourcing you do not even have to define this column in a file.
Date: defines when the rate becomes effective. This is the most important column in a file.

Suppose the following three lines appear in the currency conversion file:

From 1.1.2000 - 31.12.2009 we convert Euros (EUR) > United States Dollars (USD) using a rate of 111.
From 1.1.2010 - 31.12.2019, the conversion rate for EUR > USD is equal to 222.
From 1.1.2020 moving forward, the conversion rate for EUR > USD is 333.

See Also

If you have over half a million records in the currency conversion rate table, exporting to CSV is more efficient and faster. Either exporting to Excel^® may fail or you may run into a row limit.
If you upload currency conversion rates in a suite-integrated setup by going to Manage > Administration (in other words, the sourcing part), those rates will appear in both upstream and downstream if the Application.AQS.EnableCurrencyConversionRateSetSync parameter is enabled.
If you upload currency conversion rates into a child or parent in a non-integrated suite/setup, changes also appear in sourcing within 24 hours following the data load.
If you define a rate from EUR to USD, for example, the system automatically inverts it and calculates the USD > EUR conversion rate. For example, if you have EUR > USD rate of 2, the system automatically assumes that the USD > EUR rate is equal to 0.5. This inverse lookup does not apply to Exchange Rate Sets of sourcing events.
Triangulation does not apply to Exchange Rate Sets of sourcing events either.
Date format can be specified with hours or without, based on your preference. Both will be accepted by the system.

Formatting:

Sun Jan 1 00:00:00 PST 2012 is correct.
1-1-2012 is correct too.
31-1-2012 is incorrect. The system requires United States (US) format, so 1-31-2012 is correct.

When no hour is specified, the system assumes the default of 0:00 in the Pacific Standard Time (PST) time zone.

For sourcing events the currency conversion rates should be updated in upstream also for multicurrency bidding.

Applies To

On-Premise > On-Premise - Ariba Analysis
S2C Administration
SAP Business Network for Procurement & Supply Chain
SAP Business Network for Procurement & Supply Chain > Administration (Buyer & Supplier Account Administration)