Orders by Item Report
The Orders by Item Report reviews all sales for a particular item or group of items. You can restrict the output of this report by customer, order number range or range of order dates. Oracle Order Entry/Shipping automatically sorts this report by item, customer name, and then order number.
This report provides a listing of each item, customer name and number, order number, purchase order number, order date, ordered quantity, shipped quantity, and quantity outstanding, and subtotals for each item and customer.
Submission
In the Order Entry Reports window, enter Orders by Item Report in the Request Name field.
Parameters
When you request an Orders by Item Report, Oracle Order Entry/Shipping provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria.
Customer
Choose the customer name that you want printed in this report.
Order Type
Select the order type that you want printed in this report.
Order Number
Choose the order number(s) that you want printed in this report.
Order Date
Choose the range of order dates that you want printed in this report.
Item
Choose the item that you want printed in this report.
Item Display
Choose Description or Flexfield, depending on whether you want the item name or description to be printed in this report under the Item column heading. The default value is Description.
Show Open Orders Only
Choose Yes if you want to print only open orders or No if you want to print both open and closed orders in this report.
Order Category
Choose the order category for the orders that you want printed in this report. You can choose from Regular or Internal Sales Order. The default value is Regular.
Column Headings
Item
Oracle Order Entry/Shipping prints the name or description of the item, depending on your selection for the Item Display parameter.
See Also
Defining Order Types