Previous	Next		Contents	Index	Navigation	Glossary	Library

• The report gives evidence of completeness by listing the value of your open items before the revaluation. You can then reconcile this result to the General Ledger Balances. In addition, this report provides a complete list of all items and thus explains the balance of your receivables 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 lower of the two values, the open item before and after the revaluation. Then the report totals the lower of these values and calculates the difference between the two. This total is used in countries like Germany, where the lower market value of open items needs to be determined.

You can run this report for a revaluation period, up to a particular due date, or for a range of balance segment values.

Attention: Be sure that you enter an End-Of-Period rate (EOP) for each currency used. If any EOP is missing, a warning will appear at the end of the report to notify you that an End of Period rate was not entered for at least one currency, and the results calculated may be wrong.

Use either the Submit Request or the Print Accounting Reports window to submit this report.

Report Parameters

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

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

Report Headings

Balancing Segment: Receivables prints each value of the balancing segment in the range you selected.

Accounting Flexfield: The Accounting Flexfield of each of your accounts in the balancing segment.

Customer/Customer Number: The customer name and number, and customer site that have open items charged to the Accounting Flexfield of your receivables account.

Column Headings

Transaction Type: The transaction type. For example, invoice, debit memo, credit memo, chargeback or deposit.

Trx Date: The date of the transaction.

Due Date: The due date of this transaction.

Cur: The currency of this transaction.

Open Orig. Amount: The balance of the transaction in the currency in which it was entered.

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

Open Func. Amount: The balance of the transaction, valuated at the exchange rate used when the transaction was approved.

EOP Rate: The End-Of-Period rate. This is the rate that the report uses to revaluate the balance of the transaction.

EOP Open Amount: The balance of the transaction, revaluated using the EOP rate.

Open Revaluated Amount: Receivables uses the lower of the Open Functional Amount and the Open EOP Amount to determine the market value of the open item.

Difference: The difference between the Open Functional Amount and the EOP Open Amount for each receivables Accounting Flexfield and the difference between the Open Functional Amount and the Open Revaluated Amount.

Summary: Receivables sums the differences between the original and revaluated balance for each receivables account, for each balancing segment value, and for the entire report.