header7

Reports

Open Orders by Program and Item

 

Open Orders by Program and Item provides a list of all open selling orders for the program and items selected.  This report can be run for only one program at a time but can be run for all items in the program.  The report can be set to print only those orders within the ship date range entered.

 

 

Report Setup

 

Program ID.  Enter the program ID of the program to print.  If the program is not known, enter "?" to display the Active Programs window.  Select the program by entering the sequence number to the left of the program ID.  Only one program may be selected per report.

 

Item Class.  Enter the item class of the items to print.  C=Co-op, F=Fulfillment

 

Item Number.  Enter the item number on the open orders to print.  The report may be set to print for one item or all items.  To select all items to print, press Spacebar.  If the item number is not known, enter "?" to display the Program Items window.  Select the item by entering the sequence number to the left of the item number. 

 

Ship Via Code.  Enter the ship via code for the items and orders to print.  The ship via code is set up in Ship Via Code Maintenance on the SEO menu.  If all ship via codes are to print, press Spacebar.

 

Starting and Ending Ship Dates.  Enter the starting and ending ship dates to print.  If all ship dates are to print, press Spacebar on both fields.  If one date is all and the other is a definite date, press Spacebar accordingly.

 

Print Backorders Only.  If only the invoiced backorders are to print, enter "O".  If only backorders, invoiced and not invoiced, are to print, enter "Y".  If all items regardless of backorder status are to print, enter "N".

 

Print All Other Line Items On Order.  If only the first line item on an order is to print, enter "N".  If all line items, regardless of the number of line items, are to print, enter "Y".

 

Double-Space Report.  If the report is to print with double spacing between orders, enter "Y".  If the report is to print single spaced, enter "N".

 

Sort Order.  The orders that print on the report may be set to print in three different sequences, O=By Order #, S=By Ship Date, C=Customer Number.

 

Report Format.  Enter the format for the report to print.  If the format needed is date, item and description, enter "1".  If the format needed is city, state, and zip code, enter "2".

 

The report will print the following information:

 

Order Number.  The open order number.

 

Customer Number and Name.

 

Booked Date.  The date the order was entered.

 

Ship Date.  This is the customer ship date.

 

Last Date.  This is the last date that shipping was recorded on the order.

 

Report Format fields.

 

Item Number and Description.  This is report format "1".

 

City, State, Zip.  This is report format "2".

 

Order Quant.  The quantity field from Order Entry.

 

Shipped Quant.  The quantity shipped to date.

 

B/O Quant.  The quantity on backorder.

 

NI.  Not Invoiced.  If the order is open and not invoiced, an asterisk will appear in this column.

 

WC.  WIP code.  This is the where in process WIP code, not work in process.  If the order has an entered WIP code, the WIP code will print in this column.