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