Revalue Transactions in Other Currencies
Overview
Before
you start
- Post all outstanding multicurrency transactions and update currency information in Common Services.
- Determine the currencies to revalue and the rates to use.
- Choose Posting Journals from the Processing Reports folder, and print the Provisional Revaluation Listing to list the transactions that would be created for the exchange gain and loss general ledger accounts. You can then make any necessary changes to your selections and to currency rates before you create the general ledger transactions.
To revalue transactions:
-
Open Accounts Payable > Periodic Processing > Revaluation.
Click here for help on the fields on the Create Revaluation Batch form.
- Indicate whether
to do a provisional
revaluation
or an actual
revaluation.
Select the Provisional Revaluation option if you want to preview the revaluation transactions that will be created for the general ledger batch, select the Provisional Revaluation option.
If you do not select Provisional Revaluation, Accounts Payable creates the transactions for the general ledger batch.
-
For each currency you wish to revalue, use one line on the grid to enter the following information:
Type the currency code for which you want to specify revaluation options, or choose it from the Finder. The revaluation process selects only transactions that are in the specified currency.
Note: You cannot specify the same currency code more than once for a single revaluation. If you want to revalue different ranges of records for the same currency code, you must revalue each range separately.
Type the date of the end of the period you want to revalue (normally, the end of a reporting period).
The revaluation process selects open transactions with posting dates that are on or before the date you specify.
Earliest
backdated activity date.
This field is available only if you use the Recognized Gain/Loss accounting method for your Sage 300 ERP system. It identifies the earliest backdated document to revalue, if there is a backdated transaction in the period you are revaluing.
Type the rate type for selecting the currency table, or select a rate type from the Finder.
The revaluation process selects transactions only from specified vendor accounts that use the selected currency.
Type the date to use to select the exchange rate at which to revalue transactions for the specified currency code.
Type the rate at which to revalue transactions for the specified currency code.
-
To change the optional fields and values for a particular line or to delete optional fields, either double-click in the Optional Fields column for the line or select the line, then
click
the Optional Fields column heading.An Optional Fields form opens, showing any revaluation optional fields set up for automatic insertion and their default values. You can edit the values for existing optional fields, or add or delete optional fields for the detail. However, you can add only optional fields that you set up for use in Revaluation.
Tip: Enter the revaluation information, then select the Provisional Revaluation option to do a test run before performing the next step.
- Click Process.
After
creating a revaluation batch
- Post the revaluation batch in General Ledger.