Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Applications Administration Guide > Ongoing Application Administration Tasks >
Setting Up Currency Conversion
This section discusses how to set up exchange rates and includes related background information. It includes the following topics:
- Setting Up Exchange Rates. You must set up exchange rates used to convert currencies.
- Understanding the Euro and Triangulation. If a currency is part of the European Monetary Union, you convert it to other currencies through the Euro.
- Currency Conversion Functionality. The currency conversion rates that you set up are used by a number of features of Siebel applications.
Setting Up Exchange Rates
After you have set up your currencies, but before you use any currency features or import data with foreign currencies, you must set up exchange rates that are used to convert currencies.
If you fail to set up an exchange rate, currency will be converted on a 1:1 basis. This means that the amount stays the same but the currency symbol changes.
NOTE: To calculate exchanges between currencies, you must set up an exchange rate twice—one for each currency. For instance, if you want to calculate exchange rates between U.S. dollars and Japanese yen, you must set up an exchange rate for yen to dollars, and set up another rate for dollars to yen.
- From the application-level menu, choose View > Site Map > Applications Administration > Currencies.
- In the Currencies list, select the currency for which you want to establish exchange rates.
- Click the Exchange Rates view tab.
- In the Exchange Rates list, add a new record and complete the necessary fields.
Some fields are described in the following table.
Repeat this process to add additional exchange rates.
You must restart the Siebel client or use the clear cache command before any changes to exchange rates can be seen in your Siebel application. For more information about clearing the cache, see Clearing the Cache.
The Euro and Triangulation
NOTE: As of January 2002, the Euro Triangulation method for converting between currencies belonging to EMU members is not needed for present and future currency exchanges. However, the method is still available in Siebel applications, as are the old currencies, so that historical data can be maintained accurately. The following description applies only to historical data needing conversion prior to the 2002 switchover to the Euro for the EMU member countries.
If a country is a member of the European Monetary Union (EMU), you should convert its currency to other currencies through the Euro. This is called triangulation, and it is used whenever either currency being converted has EMU Triangulation checked.
For example, if you are converting from USD to DEM and DEM has EMU Triangulation checked, you must set up the conversion rates between US dollars and the Euro and between the Euro and US dollars. You do not have to check the EMU Triangulation field for USD. The DEM will be converted to EUR according to the fixed exchange rate set by the European Monetary Union, and then the amount in EUR will be converted to USD according the exchange rate you set up.
The EMU Triangulation field is already checked for the following European Monetary Union member nations: Germany (DEM), Belgium (BEF), Spain (ESP), France (FRF), Ireland (IEP), Italy (ITL), Netherlands (NLG), Austria (ATS), Portugal (PTE), Finland (FIM), and Luxembourg (LUF). However, you can check or clear this field. For instance, if the United Kingdom or Sweden joins the EMU, then you can check the field for that currency.
To calculate triangulation conversion, the conversion rate is always expressed to six significant figures. Conversions from one national currency unit into another are made by:
- Converting the monetary amount from the national currency unit into the Euro.
- Rounding the result to not less than three decimal places.
- Converting the result to the target national currency.
- Rounding the result to the lowest subunit of the target national currency, such as pfennig for the German mark or centime for the French franc.
NOTE: The EMU Triangulation field should be checked only for currencies that are subdivisions of the Euro.
Currency Conversion Functionality
Currency conversions currently occur in your Siebel application in various features. Some examples follow:
- Quotes. When you change the currency code of a quote, it will convert the discount amounts and discount prices.
- Forecasting. When you update forecast information from the opportunity, it will do a currency conversion from the opportunity currency to the forecast currency if the currencies are different. When you roll up the forecast lines, it will do a conversion from the forecast line currency to the rollup forecast currency if the currencies are different.
- Rate lists. When you change the currency code of a rate list, it will prompt you for an exchange date and convert the prices of all of the price list items.
- Reports. Here are some examples of reports that support currency conversion:
- Opportunity Pipeline Report by Rep. Opportunity revenues created in different currencies will be converted in the Total and Subtotal fields to the user's default currency.
- Euro Expense Report. If expenses have been created in an EMU currency, all expenses will be displayed in dual currencies.
- Project Limit Summary Report.
- Forecasting Reports.
- Current Quotes Report.
- Charts. The following charts support currency conversion:
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Applications Administration Guide Published: 09 September 2004 |