Previous	Next		Contents	Index	Navigation	Glossary	Library

This report provides you with two results:

• Independent from the accounting entries for your receivables account, this report gives you the balance of your customer and the open items that make up the balance. It takes into account paid deposits and on-account receipts; unpaid deposits are not included.

• A report listing only customers with a negative balance only, customers with a positive balance, or both kind of customers at once. This is needed in some countries, where you need a separate entry on the balance sheet for customers with a negative balance.

You can run this report for a revaluation period, up to a particular due date, and to include customers with a negative balance, customers with a positive balance, or both.

Attention: Make sure you have entered an End-Of-Period (EOP) rate for each currency used. If any EOP is missing, the report will notify you that 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 Receivables activities, you can enter a date; otherwise, you should leave this field empty.

Customer Balance: Select from the following values:

• Show positive Balance: List only customers with a positive balance.

• Show negative Balance: List only customers with a negative balance.

• Show positive and negative Balance: List all customers, regardless of their current balance. This is the default.

Report Headings

Customer Name/Number: The customer name, customer number, and customer site that have open items.

Column Headings (Report Name, if needed for different report parameters)

Transaction Type: The name of the transaction type.

Transaction Date: The date of the transaction.

Due Date: The due date of the transaction.

Cur: The currency used to enter the transaction.

Open Orig. Amount: The balance of the transaction in its original currency.

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, which 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 EOP Open Amount to determine the market value of the open item.

Credit/Debit: The sum of the positive open items (Debit) and the sum of the negative open items (Credit). These figures help you determine the amount of the adjustments to your general ledger balances.