This form enables you to input foreign exchange rates for the currency conversion process.
Prerequisites
The system requires these member tags for the Foreign Exchange Rates input form:
| Dimension | Element | Tag |
| Currency | All currency | #AllCurrency |
| Entity | Total group (main root) | #TotalGroup |
| Scenario | Actual | #Actual |
Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.
The system also requires global variables for the input form.
| Variable Name | Value |
| CurrentYear | This should be set to the name of the current year element. For example: 2026. |
Access the input form
To access the Foreign Exchange Rates input form:
- Select the Explorer module.
- Expand the Global > Consolidation > Input.
- Right-click the Foreign Exchange Rates form and select Open. Alternatively, double-click the form to open it.
Note: Your administrator may have moved the form to another location, or it may be started as part of a process.
Parameters
The key parameters of the input form are:
| Variable Name | Value |
| Period | It defaults to the value set in the global variable CurrentYear. |
| Scenario | It defaults to the scenario tagged as #Actual. |
Use the input form
Once you have selected the parameters, the input form displays:
- Rows display all source currencies along the various rate types that are defined in the system. For example, Average, EndRate, and Static.
- Columns display months under the selected year.
This form enables you to input foreign exchange rates. These rates are global rates. Use the Foreign Exchange Rates Override template if you need to override these rates for a specific entity.
Note: If the period and scenario combination selected isn't open, the input form will be locked.
In an input form, if cells are:
- White: These cells are protected and can't be edited.
- Pale Yellow: These cells are editable. The movement classification allows input for that account.
- Dark Yellow: The movement classification requires intercompany input for that account.
Dropdown lists in an input template that are selectable are white with blue text.
