How to Create a Batch of Revaluation Transactions in Sage 300 General Ledger

Steps:

  1. Open General Ledger > G/L Periodic Processing > Create Revaluation Batch.
  2. In the Batch Description field, type 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, type or select 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.  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, select the detail line on the table, and then click the Zoom button or press SHIFT+F9. The Create Revaluation 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 J/E 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.  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.