Use the Open Items Revaluation report to revalue your open items, such as invoices, commitments, credit memos, and debit memos.
This 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.
This report provides you with three amounts:
The value of your open items before revaluation, which you can reconcile with your General Ledger Balances. The Open Items Revaluation report also provides a complete list of all open items and explains the balance of your Receivables account.
The value for each revalued open item with the revaluation rate. This itemized total is needed in some countries, such as the United States.
The higher of the two item values both before and after the revaluation. Oracle Receivables totals these values and calculates the difference. This total is needed in some countries, such as Germany, 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 Open Item 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 for each asset accounting flexfield and summed for each balancing segment. You should reverse this adjustment at the beginning of the next period to synchronize Receivables and General Ledger balances.
You can run the 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.
Use either the Submit Request or the Print Accounting Reports window to submit this report.
If you are using a daily rate, then enter daily rates for the rate type you want to use, whether that rate type is predefined or user defined. See: Defining Conversion Rate Types, Entering Daily Rates.
Revaluation Period: Enter the period that you want to revalue. All open invoices with invoice 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 type of rate you want to use to revalue the open transactions:
Period. Rate at the end of the revaluation period.
Daily. If you select Daily, then also enter values for the Daily Rate Type and Rate Date.
Daily Rate Type: If you select Daily as your rate type, then select a daily rate type.
Rate Date: If you select Daily as your rate type, then select the daily rate date.
Balancing Segment Low: Enter the lowest balancing segment value for the range of values that you want to report.
Balancing Segment High: Enter the highest balancing segment value for the range of values that you want to report.
Apply Posted Transactions Only: Enter Yes if you want the report only to include transactions transferred to General Ledger. Only receipts transferred to General Ledger can decrease the transaction balance. Enter No if you want both posted and not yet posted transactions and receipts to take effect for open balances of your receivables.
Apply Cleared Receipts Only: Enter Yes if you want receipts to have an effect on the transaction open balances only if the receipts were cleared. Enter No if you want both cleared and not yet cleared receipts to take effect for open balances.
Balancing Segment From/To: Range of balancing segment values that you selected when you submitted the report.
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.
Customer/Customer Number: The customer name and number, as well as customer sites that have open items charged to the accounting flexfield of your Receivables account.
Transaction Number: The transaction number.
Transaction Type: The transaction type, such as invoice, debit memo, credit memo, chargeback, and deposit.
Transaction Date: The transaction date.
Due Date: The transaction due date.
Curr.: The transaction currency.
Open Original Amount: The transaction in the entered currency. Oracle Receivables 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.
Exchange Rate: The exchange rate for foreign currency transactions. This value is 1 for functional currency transactions.
Open Functional Amount: The functional currency balance of the transaction, valued at the exchange rate used when the transaction was approved.
Revaluation Rate: Rate that the report uses to revalue the balance of the transaction.
Revaluation Open Amount: Transaction balance, revalued using the revaluation rate.
Open Revalued Amount: The difference between the Revaluation Open Amount and the Open Functional 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 Functional Amount (with sign).
Total for [customer]: The supplier that the totals are calculated for.
Total for [balancing segment]: The balancing segment that the totals are calculated for.
Accounting Flexfield: The accounting flexfield that totals are calculated for.
Open Functional 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 Functional Amount and Revalution 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 Functional Amount and Open Revalued Amount for each accounting flexfield, balancing segment, and the entire report.
Total: The total for the report.