G/L Create Revaluation Batch Screen

Sage 300 ERP

Home > Screen Guides > Periodic Processing > Create Revaluation Batch

G/L Create Revaluation Batch Screen

Open General Ledger > G/L Periodic Processing >  Create Revaluation Batch.

Select a range of accounts that you want revalued, by specifying either a range of account numbers or a range of account number segment codes.

All accounts within the range that post to the selected currency and use the revaluation code you specify will be considered for revaluation. (If you select Yes in the Force Reval column, all accounts that have their Revaluation option set to No on the G/L Accounts screen will be revalued.)

Enter a description of up to 60 characters for the batch. The description is printed on batch listings, and appears with the batch number when you use the Finder to view lists of batches.

Specify the code for the source currency you are revaluing.

Currency codes are defined in Common Services. If a currency is not listed for an account on the G/L Accounts screen, that account will not be revalued, even if the account accepts postings from all currencies.

Specify the fiscal year for which you want accounts revalued.

Double-click this field or press the spacebar to specify whether to force 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.

Specify a range of fiscal periods to specify the time period over which the revaluation takes place.

Example: Revaluing the balances in accounts in a single fiscal period creates a single set of transactions (one transaction to post the revaluation, and one to reverse it). Revaluing a range of periods creates a set of transactions in each period (and allow you to print statements that include the revaluation in each of the periods).

Specify the journal entry date that will be entered with each transaction created by the G/L Create Revaluation Batch screen.

Select or enter an optional field code that you have set up in Common Services.

When you enter the optional field code, the program displays the description for the optional field.

This field displays the date associated with the exchange rate.

Each exchange rate in a currency table appears with a date. Sage 300 ERP selects exchange rates for transactions based on the rate type and the rate date. (Rate types tell Sage 300 ERP whether to require a rate with the current date, or accept a rate with the closest earlier or later date.)

Tip: A recent date indicates that your currency tables are up to date.

You can override the rate and the date if needed.

Specify the revaluation code to use. Revaluation codes provide General Ledger with the following information:

  • Rate type
  • Source code for transactions
  • Exchange gain account
  • Exchange loss account

Codes are defined using the G/L Revaluation Codes setup screen.

Specify the exchange rate that will be in effect for all accounts using this revaluation code.

Rate type is determined by the revaluation code, but you can change it.

When the program cannot find a rate that matches the method defined for selecting rates for the revaluation code, zeroes appear in this field, and an error message states that you must enter an exchange rate that is greater than zero.

You can define a range of accounts for revaluation in two different ways:

  • By specifying a range of account numbers
  • By specifying a range of a specific segment

Once you choose the kind of range you want, you can specify the starting and ending values for the range.

All accounts within the range that post to the selected currency and have the revaluation code you specify set to Yes will be considered for revaluation. (If you select Force Revaluation, all accounts that post to the selected currency and have the revaluation code set to No will be considered for revaluation.)

Overview

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:

  • The rate type that is used to display the default exchange rate.
  • The source code to assign to revaluation transactions.
  • The exchange gain/loss accounts to which exchange differences are posted.

For more information, see About Revaluation.

Related Topics

Related Topics