Revaluing Transactions in Other Currencies

When exchange rates fluctuate, you may need to revalue outstanding documents denominated in other currencies to reflect their present value in your own (functional) currency at a particular time, for example, at financial statement dates.

You use the A/P Revaluation screen to revalue transactions.

To revalue transactions:

1. Open Accounts Payable > A/P Periodic Processing > Revaluation.

2. Indicate whether to do a provisional revaluation or an actual revaluation. More...

   If you want to preview the revaluation transactions that will be created, select the Provisional Revaluation option.

   If you do not select this option, Accounts Payable creates the transactions for the general ledger batch when you click the Process button.

3. For each currency you want to revalue, use one line on the table to enter the following information:

   • Currency. Specify the currency code for which you want to specify revaluation options. 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.

   • Revaluation Date. 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 system. It identifies the earliest backdated document to revalue, if there is a backdated transaction in the period you are revaluing.

   • Rate Type. Specify the rate type for selecting the currency table.

     The revaluation process selects transactions only from specified vendor accounts that use the selected currency.

   • Rate Date. Type the date to use to select the exchange rate at which to revalue transactions for the specified currency code.

   • Exchange Rate. Type the rate at which to revalue transactions for the specified currency code.

4. To change the optional fields and values for a particular line or to delete optional fields, click the Optional Fields column. More....

   An Optional Fields screen 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.

5. Optionally, do a test run before performing the final step:
   1. Select the Provisional Revaluation option, if you did not select it earlier.
   2. Click Process.
   3. Print the Provisional Revaluation posting journal to list the transactions that would be created for the exchange gain and loss general ledger accounts.
   4. Make any necessary changes to your selections and to currency rates.
6. When you are satisfied with the results of the provisional revaluation, clear the Provisional Revaluation option, and then click Process to create the revaluation transactions.

Last published: 4/8/2016