Open Orders by Customer and Item is a listing of items and the total quantity of those items for all open selling orders in the system listed by the customer requested.  This report prints for only one customer at a time.  This report does not print detail as to which orders are open.  It is only a listing by customer and the items sold to the customer on open selling orders. 

Report Setup

To run the report, simply enter a customer number, if known. If the customer number is unknown, enter "? " to display a window titled Customers.  Select the customer to print by entering the sequence number located to the left of the customer number required.  If further assistance is needed to select the correct customer, press F9 .  This will expand the Customers window to show the contact and the city and state.  This may be helpful when several customers with similar customer numbers are in the same city, such as gas stations, convenience stores, banks, etc.

The report prints the following information:

Item number and description. This is the source of the sorting for the report.

Number of open selling orders. The report will show the number of open orders for each of the items listed.  It will not be uncommon for the total number of open orders on this report to be much higher that the actual number of open orders for the customer.  If there is more than one item on an order, the system will tabulate that there is an open order for each of the line items.  In this case the system would tabulate two, or three, orders as there are two, or three, line items on the open order.

Total quantity of the item on all open selling orders. The report will tabulate the quantity of the item on all open orders and display the total quantity for the item listed.

NOTE:  This report will not list any open items on any purchasing orders, such as P orders.  For a listing of the items open on P orders, refer to the ISR menu under Inventory Purchase Audit Report.