Receivables Open Items Revaluation Report

Use the Receivables Open Items Revaluation Report to revalue your open items, including invoices, credit memos, and debit memos. The report takes into account changes in the value of your receivables due to changes in foreign currency rates.

You revalue open items based on the revaluation rate that you specify, which is either an end-of-period rate or a daily rate.

The Receivables Open Items Revaluation Report provides you with three amounts:

• Open Original Amount: The value of your open items before revaluation, which you can reconcile with your general ledger balances. The report also provides a complete list of all open items and explains the balance of your receivables account.

• Revaluation Open Amount: The value for each revalued open item with the revaluation rate. This itemized total is required in some countries.

• Open Revalued Amount: The higher of the two item values both before and after the revaluation. The report adds up these values and calculates the difference. This total is required in some countries, where the lower market value of open items needs to be determined.

The report is divided into sections for each unique combination of balancing segment and receivable account. Within each section, the report lists open items for each customer.

The Receivables Open Items Revaluation Report determines the amount needed to manually adjust your general ledger balance to reflect the difference between the original and revalued balance. This revaluation difference is calculated and summarized for each accounting flexfield. You should reverse this adjustment at the beginning of the next period to synchronize Receivables and General Ledger balances.

You can run the Receivables Open Items Revaluation Report for a revaluation period, up to a particular due date, and for a range of balance segment values. Check that you have entered rate information for each currency that you use. Use the Include Up To Due Date parameter to split your assets into short-term, mid-term, or long-term receivables.

Report Parameters

Revaluation Period

The accounting period that you want to revalue. All open transactions with transaction dates up to the last date of this period are selected.

Include up to Due Date

Enter a date if you want to differentiate short-term, mid-term, and long-term receivables. Otherwise, leave this field blank. The date is the maximum due date included in this report.

Rate Type

Select the rate type to use to revalue open transactions:

• Period. Rate at the end of the revaluation period.

• Daily. If you select Daily, then enter values for the Conversion Rate Type and Conversion Date parameters.

Conversion Rate Type

If you select Daily as your rate type, select a conversion rate type.

Conversion Date

If you select Daily as your rate type, select the conversion date.

Transferred to GL Only

• Yes: Include only transactions transferred to general ledger. Only receipts transferred to general ledger affect open balances.

• No: Include both posted transactions and transactions and receipts not yet posted to affect open balances.

Cleared Only

• Yes: Only cleared receipts affect open balances.

• No: Both cleared receipts and receipts not yet cleared affect open balances.

Balancing Segment

Define the filtering conditions for the balancing segment values to include or exclude.

Report Output

This table describes the report headings in the Receivables Open Items Revaluation Report.

Report Heading	Description
Revaluation Date	The date of the revaluation.
Balancing Segment	Each value of the balancing segment for the selected balancing segment range.
Accounting Flexfield	The accounting flexfield for each of the accounts with the balancing segments within the selected range.

This table describes the column headings in the Receivables Open Items Revaluation Report.

Column Heading	Description
Transaction Number	The number of the transaction.
Transaction Type:	The transaction type assigned to the transaction.
Transaction Date	The date the transaction was created.
Due Date	The date payment is due on the transaction.
Currency	The transaction entered currency.
Open Original Amount	The transaction amount in the entered currency. The report prints an asterisk if the open amount differs from the original amount. The open amount may differ if receipts were applied or adjustments made to the transaction.
Conversion Rate	The conversion rate used for foreign currency transactions. This value is 1 for ledger currency transactions.
Open Ledger Currency Amount	The ledger currency balance of the transaction, valued at the conversion rate used when the transaction was approved.
Revaluation Rate	The rate that the report uses to revalue the balance of the transaction.
Revaluation Open Amount	The transaction balance, revalued using the revaluation rate.
Open Revalued Amount	The difference between the Revaluation Open Amount and the Open Ledger Currency Amount. During reconciliation, debit the receivables account if the difference is positive; credit the receivables account if the difference is negative. In other words, Open Revalued Amount = Revaluation Open Amount - Open Ledger Currency Amount (with sign).

This table describes row headings in the Receivables Open Items Revaluation Report.

Row Heading	Description
Customer Name	The name of the customer with items charged to the accounting flexfield of the receivables account.
Customer Account Number	The account number of the customer with items charged to the accounting flexfield of the receivables account.
Total	The transaction totals.
Total for [Customer]	The customer totals.
Total for Accounting Flexfield	The accounting flexfield totals.

This table describes the summary headings in the Receivables Open Items Revaluation Report.

Summary Heading	Description
Accounting Flexfield	The accounting flexfield that totals are calculated for.
Open Ledger Currency Amount	The total for each accounting flexfield, balancing segment, and the entire report.
Revalued Amount	The total for each accounting flexfield, balancing segment, and the entire report.
Difference	The total for the difference between the Open Ledger Currency Amount and the Revaluation Open Amount for each accounting flexfield, balancing segment, and the entire report.
Open Revalued Amount	The total for each accounting flexfield, balancing segment, and the entire report.
Difference	The total for the difference between the Open Ledger Currency Amount and the Open Revalued Amount for each accounting flexfield and the entire report.
Total	The total for the report.