Payables Open Items Revaluation Report

Use the Payables Open Items Revaluation report to revalue open items, accounting for changes in the value of liabilities due to foreign currency rate changes.

Open items include invoices, prepayments, credit memos, and debit memos that are unpaid as of the last date of the revaluation period you specify.

The report determines the manual adjustment to your general ledger balance for the difference between the original and revalued balances. The report calculates the difference for each liability account with a total for each balancing segment. You should reverse the general ledger entry at the beginning of the next period to synchronize payables and general ledger balances.

To provide a complete listing of your liabilities, the report also includes open items in the ledger currency. Those items use a revaluation rate of 1.

Note: Payments are included if the last reporting date is after the payment accounting header date and the accounting date is outside of the reporting period.

You can run this report from the Scheduled Processes work area.

Before running the report, if you use a:

• Period rate, define rates on the Currency Rates Manager page.

• A daily rate, define daily rates for the rate type, whether the rate type is predefined or user-defined.

Parameters

Business Unit

Specify a business unit.

Revaluation Period

Select a period to revalue. The report includes open items with dates up to the last date of this period.

Rate Type

Select a type of revaluation rate.

• Period: Uses the rate at the end of the revaluation period.

• Daily: Uses the daily rate for the Daily Rate Type and Daily Rate Date parameters.

Daily Rate Type

If you select a Rate Type of Daily, then select the daily rate type.

Daily Rate Date

If you select a Rate Type of Daily, then select the daily rate date.

From Balancing Segment, To Balancing Segment

Enter a balancing segment range to include in the report.

Transferred to General Ledger Only

• Yes: Includes only the transactions that are transferred to the general ledger.

• No: Includes all transactions.

Cleared Only

• Yes: Includes only payments that are cleared when determining open balances.

• No: Includes all payments when determining open balances.

Understanding the Report

The report has sections for each unique combination of balancing segment and liability account. Within each section, the report lists the open items for each supplier.

This table describes the amounts on the report.

Amount	Description
Ledger Unpaid	The value of open items before revaluation, which you can reconcile with your general ledger balances.
Revalued	The value for each open item revalued using the revaluation rate. Some countries, such as the United States, require that you report this total.
Revalued Unpaid	The higher of the two item values both before and after revaluation. Some countries require this total, such as Germany, where the higher market value of open items has to be determined.