How to Revalue Transactions in Sage 300 Accounts Payable


  1. Open Accounts Payable > A/P Periodic Processing > Revaluation.
  2. Indicate whether to do a provisional revaluation or an actual revaluation.  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 Process.  
  3. For each currency you want to revalue, use one line on the table to enter the following information:
    • Currency. 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.
    • 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. 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.
    • 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, 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 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.