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.


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 a maximum of three new Global Rate accounts (for a total of five Global Rate accounts) and additional Local Rate accounts. Rate data entered to Global Rate accounts is applied to all entities while rate data entered to Local Rate accounts is entered on an entity-by-entity basis.

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

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

After you create a new 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.

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 perform the Compute Rate process in Data Forms or in the Rules card, the system 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. Entity-specific rate data entered to Local Rate accounts is stored in the Consol cube and no additional calculations are performed.

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.


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

    Note that if a total of five Global Rate accounts already exist (the maximum permitted), the Rate Type will default to Local Rate and cannot be changed. To add a new Global Rate account, an existing Global Rate account must first be deleted.

  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.