A multicurrency conversion list stores a list of currencies and conversion criteria that enables transactions to be converted from a base currency to other currencies. The conversion list is attached to a price list or agreement that uses the conversion criteria to convert the base list prices to the foreign currency amount. Multiple conversion methods can be in effect at a time for a currency. For example, if converting USD (US dollars) to FRF (French francs), you could have a fixed conversion type for March and a formula conversion type for April. If more than one multicurrency conversion list is set up for the same base currency, then you must assign each conversion list a unique name.

Conversion types determine how the conversion rate is calculated. Some of these seeded conversion types are available only if Oracle General Ledger is installed; however, you can still link to other non-Oracle stored conversion rate information by using the formula functionality. The following seeded conversion types are available:

• Fixed: Enter a fixed value that is used as the conversion rate. For example, if you enter a value of 1.5, the list price from the base price list is multiplied by 1.5 to get the converted amount.

• Formula: Attach a pricing formula, and the value returned from the formula is the conversion rate. You cannot use as a conversion formula with a component type of PLL (Price List Line) because the line may have a different base currency than the price list to which this currency conversion criteria is attached.

• Transaction: Users of the calling applications (such as Oracle Order Management) enter the conversion rate. In these cases, the rate entered is converted from transaction currency (for example, from the price list currency) to functional currency (such as the sales order). For other conversion types, such as Fixed, the rates entered in the multicurrency window is from base currency to transaction currency.

  The following conversion types are available only if Oracle Financials (General Ledger) is installed:

• General Ledger sourced (Corporate, Spot, EMU Fixed, User Defined): Gets the conversion rate between the base currency and currency to from Oracle General Ledger. These conversion types are available only if Oracle Financials (General Ledger) is installed.

   To create a multicurrency list:

1. Navigate to the Multi-Currency Conversion List window.

2. Complete your entries in the Multi-Currency Conversion window. All the fields in the Multi-Currency Conversion List are applicable to the base currency:

   • Base Currency Code: Enter the base currency code for the currency that the price list is set up in. For example, if the price list has a base currency of US dollars, enter the code for US dollars such as USD.

   • Name/Description: Enter a name to identify the multicurrency list and a description.

   • Base Round To: Enter a value that rounds the selling prices to the decimal place that is entered. For example, if you entered a Base Round To value of -2, a price calculated as $9874.343 is rounded to $9874.34.

     Note: If the QP: Price Rounding profile option is set to enforce currency precision, then you cannot update the Base Round To value in the Multi-Currency Conversion List. To make a change, you must first change the profile setting to Enforce Rounding Factor or NULL. Then change the Base Round To value. Finally, you can change the profile setting back if desired.

   • Base Markup Operator: Optionally, select Percent (%) or Amount as the Base Markup Operator that can be applied against the base currency. This Operator determines how the system applies the Base Markup Value.

   • Base Markup Value: Enter a numeric value. This value is applied as either a percent or amount, depending on the value defined in the Base Markup Operator field.

   • Base Markup Formula: Enter a formula. The value returned by this formula is applied as a markup to the base currency. When entered, the Base Markup Value can be used within the Base Markup Formula [component type as modifier value (MV)].

3. In the Conversion Criteria Detail region, specify the criteria in the following fields to convert the base currency to the currency selected in the Currency To field:

   Field	Meaning
   To Currency Code	Enter the currency code for a currency that a price list can be converted to using the conversion criteria setup. For example, to convert a base currency in US dollars to Canadian currency (CAD), you enter CAD as the Currency To.
   Start Date	Start of the currency conversion.
   End Date	End date of the currency conversion.
   Conversion Type	Select one of the following conversion types: Fixed: Enter a fixed number that is used as a fixed conversion rate. Formula: For this type, the value returned by the formula becomes the conversion rate. Transaction: Uses the conversion rate or conversion type from the Order Management Sales Order. The following conversion types are available only if Oracle Ledger is installed: Corporate, Spot, EMU Fixed, and User Defined.
   Fixed Value	Enter a numeric conversion value if Fixed was selected in the Conversion Type field.
   Formula	Select a pricing formula name if you selected Formula in the Conversion Type field. The value returned by the formula is the conversion rate. A formula with a component type as PLL (price list line) is not allowed in a conversion formula because the PLL line may have a different base currency than the price list to which this currency conversion criteria is attached. A formula with a component type as MV (modifier value) is also not allowed.
   Conversion Date Type	Select a conversion date type if the value in the Conversion Type field is not Fixed, Formula, or Transaction. There are two conversion date types: Pricing Effectivity Date: Uses pricing effectivity date passed by the sales order Fixed: Uses Conversion Date setup for this currency.
   Conversion Date	Enter a date if the Conversion Date type is Fixed. This date is used to retrieve the daily conversion rate from GL (Oracle General Ledger).
   Attribute Type	Product Attributes, Pricing Attributes, and Qualifier Attributes are valid values for this field. This specifies the type of attribute to be set up for a currency conversion. This is an optional field.
   Attribute Context	This is a mandatory field if you entered an attribute type. Enter the Attribute Context for the selected attribute type. For example, if the Attribute Type value is Product Attribute, then its context can be ITEM.
   Attribute Code	This field depends on the value that you entered in the Attribute Context field. For example, if the Attribute Context field value is ITEM, the Attribute Code field contains its attributes like Item Number. This is a mandatory field when the Attribute Context is entered.
   Attribute Value	This field gives the values of the attribute code entered. For example, if the Attribute Code field value is Item Number, the Attribute Value field displays all the items. This is a mandatory field when you enter the Attribute Code value.
   Attribute Meaning	This field displays the description of the Attribute Value field. This is a display-only field.
   Precedence	Enter a numeric value if more than one conversion has the same Currency To, Start Date, and End Date but has different attribute values. See the Precedence example following the table. The pricing engine uses the precedence value to determine selection priority. If more than one of the attributes passed from OM Sales Order matches with the attribute setup for currency conversions, then the one with the lowest precedence value is selected by the pricing engine for conversion.
   Markup Operator	Select either Percent (%) or Amount. This operator is applied to either Markup Value or Markup Formula, whichever is entered.
   Markup Value	This is a numeric constant value that can also be used in the Markup Formula.
   Markup Formula	Select a formula. You cannot use a formula with Component Type PLL (Price List Line) as a conversion formula because the PLL line may have a different base currency than the price list to which this currency conversion criterion is attached. Note: You can enter both a Markup Value and Markup Formula, provided that the Markup Value is used within the Markup Formula. In this case, the final value is the value returned after computing the Markup Formula.
   Conversion Rounding Factor	Enter a numeric conversion rounding factor that rounds the list price after the conversion and markup is applied. This rounding factor could be different for the same Currency To value.
   Round To	Enter a numeric Round To value that rounds the selling price after the modifiers are applied. This value is always the same for a Currency To. Note: If values for both Conversion Rounding Factor and a Round To are entered for a currency conversion, the Conversion Rounding Factor is applied first followed by the Rounding Factor. This will be applicable for every item (except for the service item) in every pricing event.

   Precedence Example

   When two conversion types with different attribute codes are passed from an Order Management sales order, for example:

   • Country = India and

   • Item Cat. = CD Pack,

   then the pricing engine selects the attribute with the highest precedence. Therefore, 1 is selected before 2 and so on. In this case, the attribute Country = India is selected by the pricing engine because its precedence value (1) is greater than the precedence value of Item Cat. = CD Pack (which is 2).

   To Currency Code	Conversion Type	Attribute Code	Attribute Value	Start Date	End Date	Precedence
   FRF	Fixed	Country	USA	3/1/01	3/31/01	4
   FRF	Fixed	Country	India	3/1/01	3/31/01	1
   FRF	Fixed	Item Cat	CD Pack	3/1/01	3/31/01	2
   FRF	Fixed	-	-	3/1/01	3/31/01	3

   To attach the multicurrency conversion list to a price list:

Once you have created a multicurrency conversion list in the Multi-Currency Conversion window, you can attach it to a price list or agreement. You can select the Multi-Currency Conversion List from the Currency Conversion Criteria field in the price list or agreement.

1. Navigate to the Advanced Pricing - Price Lists window.

2. Select the multicurrency list from the Multi-Currency Conversion field.

   The field displays all currency conversion lists where conversion criteria base currency = currency of the price list.

   When multicurrency is enabled, the Round To field in the price list is grayed out; you can update it only in the Multi-Currency Conversion window.

3. Save your work.

   To attach the multicurrency conversion list to an agreement:

1. Navigate to the Pricing Agreements window.

2. Enter Agreement Type: Standard or Agreement.

   • For standard agreements, you must select a price list. The base currency, rounding factor, and multicurrency conversion attached to that price list default to the window.

   • For agreement price lists, in the Pricing tab, select a multicurrency conversion.

     For Agreement price lists, you can select lists where the base currency of the multicurrency conversion list is the same as the base currency of the agreement. When multicurrency is enabled, the Rounding Factor field in the agreement is grayed out; you can update it only in the attached multicurrency conversion.

3. Save your work.

   To attach a multicurrency price list as a qualifier for a modifier:

A modifier has a single currency. You must create currency-specific modifiers.

Modifiers can be created in different currencies. The modifier is selected and applied when the modifier currency is the same as price list's Base or To Currency.

1. Navigate to the Advanced Pricing - Define Modifier window.

2. Do a search or create a modifier and its respective currency; for example, a modifier in CAN (Canadian dollars).

3. Click the List or Line Qualifiers button to display the qualifiers window.

4. Enter Modifier List in the Qualifier Context field.

5. Enter Price List in the Qualifier Attribute field.

6. Select a Price List that has Base Currency or To Currency defined with the same currency as in the modifier header.

7. Save your work.

   To use Promotional Good type of modifier line:

For a Promotional Good (PRG) type of modifier line, in the Get Product list for the list line, you must select the price list whose currency is the same as the modifier currency.

If you create a promotion with a Get Item, you must ensure that the base currency for the modifier (promotion) price list is the same as the base currency for the Get Item price list (header). Otherwise, the pricing engine will not select or apply the Get Item.

1. Navigate to the Advanced Pricing - Define Modifier window.

2. Query or create desired modifier for the promotional good that uses the foreign currency (for example, French Francs).

3. In the Modifier Summary window, select a line with the Modifier Type of Promotional Goods.

4. Click Define Details to display the Define Modifier Details window.

5. In the Get region where you specify the Get Item details, select the required information about the Get Item.

6. In the Get Price field, select a price list from the Benefit Price field where the Base Currency = FRF has been defined.

7. Save the modifier record