Using the Currency Conversion Template

The Currency Conversion template converts account values to reporting currencies using system type accounts or accounts that you select.

You use the Currency Conversion template in Planning applications that are created with multiple currencies selected.

For an example of using the Currency Conversion template, see Currency Conversion Template Example.

Note:

If the Planning application is created with multi-currencies, the Currency Conversion template does not display in the list of System Templates.

To use the Currency Conversion template:

1. Create or open a business rule or a template.
2. Do one of the following:

   • For a graphical rule or template, under New Objects, select Currency Conversion, and then drop it into the flow chart between Begin and End.

   • For a script rule or template, expand System Templates, then select Currency Conversion, and then drop it into the desired area in the script.

3. Enter the requested information in the Currency Conversion Wizard.

Table 6-7 Currency Conversion Wizard Steps

Step	Explanation
Information - Currency	Describes the function of the template and what information you need to use the template.
Exchange Rate Option	Answer the questions in the wizard about currency: In what dimension is your currency? Select the dimension that corresponds to your currency dimensions. Select the reporting currency. Select the reporting currency to which you want to convert. Select the parent member that contains your currency members. Select the parent member that is the parent for all of the currencies used in your application; for example, "Input Currencies. " What exchange rate (currency) is used for this reporting currency? Select the currency that corresponds to the reporting currency you selected above. For example, if you selected EUR Reporting for the reporting currency, you would select EUR (where EUR is the currency used to convert data to EUR Reporting). Do you want to use the account types for currency conversion? Select Yes to use account types for currency conversion. If you select Yes, Expense and Revenue accounts will use average exchange rates and Liability and Equity accounts will using ending exchange rates for conversion. If you select No, you are prompted later in the wizard to specify what accounts to use for the average and ending exchange rates Do you want to calculate average exchange rates? If you select Do Not Calculate Average, the steps related to average are not displayed, and the script for calculating currency based on average exchange rates is not generated. Do you want to calculate ending exchange rates? Select whether to calculate ending exchange rates. If you select Do Not Calculate Ending, the steps related to ending are not displayed, and the script for calculating currency based on ending exchange rates is not generated.
POV	Select the members to use in the conversion to the reporting currency. The following options are available to select members. Click next to Use Predefined Selection, to select variables to populate all the dimensions with values. Click next to Member Selector, to select members for each dimension. Select a dimension, and then click to select a variable, member, or function.
Accounts Average	Enter the account(s) to use the average exchange rate to convert to the reporting currency. Note: This step is displayed only if you selected No in Do you want to use the account types for currency conversion? on the Exchange Rate Option step.
Accounts Ending	Enter the account(s) to use the ending exchange rate to convert to the reporting currency. Note: This step is displayed only if you selected No in Do you want to use the account types for currency conversion? on the Exchange Rate Option step.
FX Average	Select the members that contain the average exchange rates. Note: You only need to select the members that are different than the members in the Point of View.
FX Ending	Select the members that contain the ending exchange rates. Note: You only need to select the members that are different than the members in the Point of View.