Currency and Value Selections

  1. Click the Currency and Value Selections tab in the Ledger Revaluation Profile (LEP) dialog
  2. Specify this information in the Source and Target Currencies section:
    Source Currency

    The transaction value to be revalued. This value will not be updated on the revalued transactions. The following options are available, depending on the business unit setup:

    • Value 1 - to use the base currency values as the basis for your revaluation
    • Value 2 - to use the transaction currency values as the basis for your revaluation
    • Value 3 - to use the second base / reporting currency values as the basis for your revaluation
    • Value 4 - to use the fourth currency values as the basis for your revaluation.
    Target Currency

    The target value for the revaluation. This is the transaction value that will be recalculated from the source transaction value. You can only choose one of the following options as the target:

    • Value 1 - the base currency
    • Value 3 - the second base / reporting currency
    • Value 4 - the fourth currency

    You cannot recalculate the transaction currency values.

    Note:  The target currency and the source currency cannot be the same. Where Value 4 is used, a direct relationship between the source and target currencies must exist, that is, the system will verify that the fourth currency is calculated from the other currency according to the settings in Business Unit Setup.
  3. Specify this information in the Suppress Currency Values section:
    Suppress Currency Value 1 - 4

    Check the check box for a currency value if you want to exclude it from revaluations that use this profile. The suppressed value is written as zero in the revaluation transactions. However, the source currency code is retained for each transaction, unless it is consolidated for the currency value, using the relevant currency option on the Consolidation Options tab.

    You cannot suppress a currency value if it is selected for Source Currency or Target Currency.

  4. Specify this information in the Currency Code Selection Ranges section:
    Conversion Code From / To

    The range of Value 2 currency codes required in revaluations that use this profile. Only transactions that reference these currencies as the transaction currency (Value 2) are revalued. Leave blank to include all currency codes.

    4th Currency Conversion Code From / To

    The range of Value 4 currency codes required in revaluations that use this profile. Only transactions that reference these currencies as the fourth currency (Value 4) are revalued. Leave blank to include all currency codes.

  5. Specify this information in the Unrealized Exchange Accounts section:
    Net/Loss Account

    The account where you want to post the losses resulting from revaluations that use this profile, or net gains and losses, depending on the Exchange Gain/Loss Post Rule set for the ledger on the Ledger Setup (LES).

    Note:  If the post rule in Ledger Setup (LES) is amended, Ledger Revaluation (LER) will continue to use the unrealized exchanged accounts specified on the revaluation profile. Therefore, in this circumstance you should edit the revaluation profile to specify the new or changed account(s).
    Gain Account

    The account where you want to post the unrealized gains resulting from revaluations that use this profile. This account is only required if gains and losses are to be posted separately.

  6. Specify this information in the Currency Rate Type section:
    Currency Rate Type

    Currency Rate Types can be used for specific Ledger Revaluation Profiles (LER) so that the selected currency period rate is automatically used during the revaluation process. If it is not specified the Default rate type is used.

    Before posting the revaluation transactions it is recommended that you make sure the period rates to be used have been defined on the selected rate type.

    Select a Currency Rate Type from the list. If it is not specified the Default rate type is used.

  7. Save your changes.