How to Setup and View Currency Exceptions

Setup Currency Exceptions

1. Access the Currency Exception Setup page by navigating to Maintenance > Currency >Currency Exceptions.

2. Select a reporting currency. This list is populated based on the name and code assigned to the reporting member defined on the Segment Hierarchies page. Select the reporting member, then set up exceptions for that member. For example, you want to have an expense account converted at an AVG rate for Local Currency to Common Currency and Interim Currency conversions as well as the same expense account converted at a weighted AVG or EOM rate.

3. Click the Add button to select companies in the right pane (hold the shift key to select multiple accounts /companies at once) and click Add.

4. Select the exception value in the Currency Exception field and click Save. Currency Type for account 2055 is Avg (shown below in Hierarchy Management). However, when the exception is copied to this account, it will be calculated with BOY when the Consolidation Process is run.

   

   

5. Click Copy To to map company exceptions to accounts.

6. In the Copy To - Accounts dialog page, select accounts and click Copy.

7. Click Save.

How to View all Currency Exceptions

On the Currency Exception Setup page, click Output All to download and view an Excel spreadsheet with defined currency exceptions. This spreadsheet lists accounts by code and name, company, and exception information. An example is provided below. In this example, company 1010 is converted with a BOY exception for accounts, 1090, 1100, 1102, and so on.