You may also need to enter override rates, but they aren't mandatory. The Foreign Exchange Override Rates web form stores override rates. These rates override the global rates for specific intersections. For example, customers may need to use override rates for Equity accounts, such as Dividends and Common Stock, when a spot rate is required rather than Global Rates.
To access the form:
- Select the Maintain module.
- Select the Foreign Exchange Override rates form within the Conversion card.
The form contains columns:
| Column | Description |
| Rate | Enter the specific exchange rate value. |
| Local Currency | Select the currency for which this rate applies, for example, EUR. |
| Reporting Currency | Select the reporting currency member you're converting to. For example, you're converting local currency to USD for reporting purposes. |
| Account | Select the account for which this rate applies. |
| Audit | Select the Audit member for which this rate applies. |
| Date | Select the time period for which this rate applies. |
| Entity | Select the Entity member for which this rate applies. |
| Entity Parent | Select the Entity Parent member for which this rate applies. |
| Intercompany | Select the Intercompany member for which this rate applies. |
| Movement | Select the Movement member for which this rate applies. |
| Scenario | Select the scenario for which this rate applies. |
| Custom dimensions | Custom dimensions, for example, Department or Product, will appear in a column. Select the member for each custom dimension for which this rate applies. |
The table provided contains the icons and their respective functions in the Foreign Exchange Overide Rates form.
| Icon | Description |
 | Bulk Import lets you upload a file with financial exchange override rates. You choose the file and choose a comma, a semicolon, or a pipe as your delimiter. You can then choose to append the new rates to your existing rates or replace the current rates with the new ones from your file. |
 | Bulk Export lets you download your current foreign exchange override rates. You can choose a comma, a semicolon, or a pipe as your delimiter. |
 | Refresh your rates. This reverts the unsaved exchange values in the grid to the last saved values. |
 | Save the changes to the foreign exchange override rates. |
Enter override rates
To edit a rate:
- Select the cell and enter a new value.
- Select the Save icon on the toolbar.
- Input Validation: The system validates data upon entry. If a negative number is entered, an error message is displayed, and the cell is highlighted. The entry must be corrected before saving.
- Global override rates updated successfully message will appear.
You can import or export rates by selecting the Import or Export icons on the toolbar.
Note:
- The Foreign Exchange Rate and Foreign Exchange Override Rates web forms replace the legacy forms in Explorer. The Add-in isn't required to view and input exchange rates.
- The Override FX Rate legacy XML form is no longer available. Update and point to the new editor version of the forms for existing workflows or homepages with links to the .xml form.
- Users with the Admin or Administrator role will automatically have read access to the Foreign Exchange Override Rates web editor. Additional access for other roles can be set in the Role Authorizations tab of the Security module.
- For override rates to work, it isn't mandatory to enter all the fields. Only key fields are needed, such as Rate, Base currency, reporting currency, scenario, date, entity, account, etc. Anaplan Financial Consolidation will apply the same override rate for all the dimension members in the fields that are left blank.
