Entering Currency Rates
Currency rates are used during translation and consolidation. You maintain currency rates for each application by entering the data to the currency members manually in the data grid or by loading the rates from an ASCII file. See Loading Data.
For each application currency, the From Currency and To Currency dimensions contain system-defined currency members. You must input currency rates to accounts that have the Currencyrate account type.
You translate currency rates in the From Currency dimension to the currency in the To Currency dimension.
You enter currency rates in data grids using these point of view grid settings:
-
Row Dimension = From Currency
-
Column Dimension = To Currency
-
Row List and Column List = Member lists that you created containing the application currencies, or the Currencies system list
Table 5-1 Point of View for Currency Rates
Dimension | Description |
---|---|
Scenario |
Scenario to which the currency rate is applied |
Year |
Year to which the currency rate is applied |
Period |
Period to which the currency rate is applied |
View |
YTD |
Entity |
Entity to which the currency rate is applied, or None If None, the system uses the default currency rate. |
Value |
Entity Currency |
Account |
Account you create to contain currency rates. Account type must be "currencyrate," which you specify in the metadata load file. |
Intercompany Partner |
ICP None |
From Currency |
Source currency Select the Currencies system member list. |
To Currency |
Destination currency Select the Currencies system member list. |