Creating Rate Accounts for Translation Overrides

In addition to the "Average Rate" and "Ending Rate" system Rate accounts that are created as part of the application, you can create additional Rate accounts. These user-defined Rate accounts are used for Translation Override rules to perform special translations using a different set of Rate data. You can create, edit, or delete user-defined Rate accounts.

Note:

You must be a Service Administrator to create, edit, or delete user-defined Rate accounts.

Power Users and other Users are not able to access Translation Rules and cannot view or modify any user-defined Rate accounts.

See these topics:

You can create these types of Rate accounts:

  • Global Rate

  • Local Rate

Guidelines for Global Rate Accounts

You can add up to 18 Global Rate accounts, for a total of 20 accounts including the two system-created members.

After you create a new Global Rate account, or perform any account maintenance on one, you must perform a Refresh Database. When you refresh the database, the system updates the "Entered Exchange Rates" and the "Exchange Rates" account hierarchies.

The new user-defined Global Rate account is inserted as a child member of "Entered Exchange Rates". It is a level 0 member of that hierarchy, and a sibling to the two existing system Rate accounts - Average Rate and Ending Rate. It has the same properties as the system Rate accounts.

When you create new Global Rate accounts, these seeded system Rate forms automatically include the newly defined accounts:

  • Enter Exchange Rates – Multi Period

  • Enter Exchange Rates – Single Period

  • Exchange Rates

Rate data entered to Global Rate accounts is applied to all entities.

The system automatically computes rates if any cell has been edited on a form targeting the Rates cube. It computes the rates for all Global Rate accounts, including the new user-defined Global accounts. All of the computed Global Rate data is stored in the Rates cube and can be viewed in the seeded Data Forms.

Guidelines for Local Rate Accounts

After you create a new Local Rate account, or perform any account maintenance on one, you must perform a Refresh Database. When you refresh the database, the system updates the "Entered Exchange Rates"and the "Exchange Rates" account hierarchies.

The new user-defined Local Rate account is inserted as a child member of Exchange Rates -> Local rates. It is a level 0 member of that hierarchy.

When you create new Local Rate accounts, the Local Exchange Rates seeded Rate form automatically includes the newly defined accounts.

The seeded Local Exchange Rates data form allows you to enter rate data related to the different currencies being translated. Only Direct rate is supported for Local Rate accounts. No indirect rates or cross rates are computed.

You can enter Local Rate data for a base or a Parent entity. You can specify different Local Rates when translating to different Reporting Currencies.

Note:

The "Global Assumptions" entity is not valid for Local Rate data.

All of the computed Local Rate data is stored in the Consol cube.

To create user-defined Rate accounts:

  1. On the Home page, click Application and then click Consolidation.

  2. From the Consolidation Process page, select the Translated tab.

  3. From the list of rules, select Translation Overrides.

  4. Click Manage Rate Accounts.

    The system opens a popup box listing all available user-defined Rate accounts.

  5. Click (+) to create a new Rate account.

  6. Enter a Name, Description, and Alias.

    Note:

    The Alias information is used in the Default Alias table.
  7. For Rate Type, select Global Rate or Local Rate.

  8. Click OK.

  9. Click Close to close the Manage Rate Accounts dialog box.

    If the system detects that changes have been made, this message is displayed:

    "To apply Rate account changes to the application, you must refresh the database. Would you like the System to perform Database Refresh upon close?"

    • If you select Close and Refresh, the system opens the Refresh Database popup.

    • If you select Close (without a Database Refresh), the system displays this warning message: "You must manually perform Database Refresh so that Rate account changes can take effect." Click OK to exit the message box.