Cash Expectations Report

This report print a list of invoiced sales orders due for payment, in chronological order, in descending order of payment due date. The payments are further subtotalled in ten-day increments and within each ten-day group, by customer ID. This helps you predict your cash intake. A running total of the amount due on each invoice and the discounted total are displayed so you can see the benefit of early payment on all invoices.

Procedure

Use the Query Window to refine your list of records. Common uses would be to:

• List records for only one Customer ID.

• List only those invoices linked to a particular EMPLOYEE ID. This is useful if your salespeople are responsible for their own collections, or to get a clearer picture of the cash being generated by each rep.

• Avoid printing past due items on the report. Usually any items past due appear at the top of the report, but since these items may consist largely of contested amounts, this distracts from the true purpose of the report. To eliminate these, enter the current date like this:

•       Due Date > 12/15/97

 … as one of your Filter Options. (Remember to substitute the current date for ‘12/15/97’.)