Creating a Revaluation Batch

Learn more

G/L Revaluation Codes Screen

G/L Create New Year Screen

Use the G/L Create Revaluation Batch screen to revalue the functional-currency equivalents of each specified source-currency amount using the exchange rate you enter.

When you create a revaluation batch, General Ledger:

  • Recalculates the functional-currency-equivalent values of source-currency account balances at new exchange rates.
  • Creates a transaction for the difference between the old functional-currency-equivalent and the new value, posting the difference to the account being revalued and to the unrealized exchange gain/loss accounts or to the recognized exchange gain/loss accounts.

The revaluation code assigned to an account determines:

  • Define revaluation codes using the Revaluation Codes screen, then use the Currency tab of the G/L Accounts screen to assign the codes to the accounts you will revalue.
  • Update currency exchange rates.
  • Post current batches.
  • Back up your data.
  • Determine the range of accounts and fiscal periods, revaluation codes, date, and rate to use for each currency you want to revalue.
  • Decide whether to revalue by a range of account numbers or segment codes, and whether to force revaluation of accounts that are set to No for revaluation.

To create a batch of revaluation transactions:

  1. Open General Ledger > G/L Periodic Processing > Create Revaluation Batch.
  2. In the Batch Description field, enter a brief description for this revaluation (such as Currency devaluation 05/05/2019). You can use up to 60 characters for the description.
  3. Tab to the first line in the table.
  4. In the Currency Code field, enter the code for the source currency that you are revaluing.
  5. In the Revalue By field, specify how to select accounts for revaluation.

    You can select accounts by account number or by segment.

  6. In the From and To fields, specify a range of account numbers or segment codes to revalue.

  7. If you use optional fields, check or change the optional fields assigned to the revaluation batch. More...

    If the exchange gain/loss account used by a revaluation code uses any optional fields, the program sets the Optional Fields column to Yes for that line. You cannot change the selection directly. However, if the setting is Yes, you can add or delete optional fields for that revaluation code.

    To view or edit the optional fields used for a revaluation code, click the Optional Fields field for a detail line on the table, and then click the Finder Image of Finder button. in the field. The Optional Fields screen that appears shows the transaction optional fields assigned to the exchange gain/loss accounts for the revaluation code, along with their default values. You can accept or change optional field values, as you require.

    You can delete optional field codes used in the revaluation batch, if necessary.

    You can add only optional transaction fields that are defined for the exchange gain and exchange loss accounts assigned to the revaluation code.

    Note: Optional field information is included in the journal entry details only if the optional fields in the revaluation match the transaction optional fields assigned to the affected exchange gain/loss accounts.

  8. Specify the Revaluation Code. The code you select determines the rate type to use when revaluing balances, as well as the source code and exchange gain or loss account to which to post the resulting transactions.
  9. Use the Fiscal Year, From Period, and To Period fields to specify the fiscal year and the range of fiscal periods to include in the revaluation.
  10. In the Journal Entry Date field, enter the journal entry date. (The default date is the session date.)
  11. In the Revaluation Rate and Rate Date fields, enter the exchange rate and date at which to revalue account balances.

  12. Specify whether or not to force currency revaluation. More...

    If you force revaluation, General Ledger processes all accounts that meet all of the following conditions:

    • Within the specified range
    • Post to the selected currency
    • Revaluation option set to No for this currency on the G/L Accounts screen

    If you do not force revaluation, General Ledger processes all accounts that meet all of the following conditions:

    • Within the specified range
    • Post to the selected currency
    • Revaluation option set to Yes for this currency on the G/L Accounts screen
    • Revaluation code exists on the G/L Accounts screen for this currency

    If you do not list the currency on the G/L Accounts screen, the account will not be revalued, even if you accept posting from all currencies.

  13. Enter as many currencies as you need to revalue, and then click Process.
  • Print and then check the batch listing.
  • If necessary, edit the batch, print a new listing, and then post the batch.