Open Items Revaluation Report (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Open Items Revaluation Report

Use this report to revaluate your open items, for example, invoices, prepayments, and credit and debit memos that are not fully paid. This report takes into account the changes of the value due to changes in the foreign currency rates. The report provides you with three important figures:

The report gives evidence of completeness by listing the value of your open items before the revaluation. This result is reconcilable to the General Ledger Balances. In addition, this report provides a complete list of all items and thus explains the balance of your liabilities account.

The report calculates the value for each open item revalued with the End-of-Period rate. The total of these itemized values is needed in countries like the United States.

On an item by item basis, the report determines the higher of the two values, the open item before and after the revaluation. Then the report totals the higher of these values and calculates the difference between the two. This total is used in countries like Germany, where the higher market value of open items needs to be determined.

Use the result of this report to determine the amount you need to manually adjust your general ledger balance to reflect the difference between the original balance and revaluated balance. This difference is calculated by the report for each liability Accounting Flexfield and summed for each balancing segment value. You would then reverse this entry at the beginning of the following periods to resynchronize your liabilities with general ledger accounts.

You can run this report for a revaluation period, up to a particular due date, or for a range of balance segment values. Make sure that you have entered an End-Of-Period rate (EOP) for each currency used. If any EOP is missing, the report will notify you that the results calculated may be wrong. The due date parameter allows you to split your liabilities into shots term, mid-term, and long-term liabilities.

A warning is printed at the end of the report, if an End Of Period rate was not entered for at least one currency.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Revaluation Period. Period for which you want to revaluate.

Include Up To Due Date. If you want to differentiate short-term, mid-term and long-term liabilities, you can set a date. Otherwise leave this field empty.

Balancing Segment Low/High. Range of the balancing segment values you want to report on.

Selected Report Headings

Balancing Segment From/To. Range of balancing segment values you selected when you submitted the report.

Balancing Segment. Value of the balancing segment in the range you selected.

Accounting Flexfield. Accounting Flexfield of each of your liabilities account in the balancing segment.

Transaction Number. Number of the transaction

Due Date. Due date of the transaction.

Cur. Currency used to enter the transaction.

Open Orig. Amount. Balance of the transaction in the currency in which it was entered.

Exchange Rate. Exchange rate for foreign currency transactions. This value is 1 for functional currency transactions.

Open Func. Amount. Balance of the transaction valuated at the exchange rate used when the transaction was approved.

EOP Rate. End-Of-Period rate, the report uses to revaluate the balance of the transaction.

EOP Amount. Balance of the transaction, revaluated using the End-Of-Period rate.

Open Revaluated Amount. Payables uses the higher of the Open Functional Amount and the Open EOP Amount to determine the market value of the open item.

Difference. Payables calculates the difference between the Open Functional Amount and the EOP Open Amount for each liability Accounting Flexfield. The difference is then summed for each balancing segment value and for the report.

Difference. Payables calculates the difference between the Open Functional Amount and the Open Revaluated Amount for each liability Accounting Flexfield. This difference is then summed for each balancing segment value and for the report.

Contents

Index

Navigation

Glossary

Library