Running the Product Orders Report

This report lists all products that have been ordered during a designated period for the selected branches, including the following:

Customer ID of customer that ordered
Order number
Quantity ordered
Quantity shipped
Extended price

To run the Product Orders Report:

From the Reports > End of Month Reports > Product Sales Reports menu, select Product Orders to display the Product Orders Report window.

In the Branch field, enter the branch or territory to include in this report. To include all branches and territories, enter ALL.
In the Start Date and End Date fields, enter the date range for which to view orders. These fields both support variable dates.

Complete or change the following fields, as needed:

Field	Description
Select By	Indicates whether to run the report for price lines, sell groups, buy lines, buy groups, products, or product select codes. Based on your selection, the system names the next field accordingly. For example, if you enter Price Line in the Select By field, the next field is called Price Line.
(Price Line / Sell Group / Buy Line / Buy Group / Product / Product Select Code)	The value to use to select a subset of transactions for the report’s sales analysis. Use the Multi Items button to enter multiple values. Multiple displays in the field.
Sort by	Sorts the data on the report by a specific column or group of columns. The default value is by Customer.
Product Loc Qty Type	Selects products for the report based on their return status type, such as Stock or Defective.

In the Customer Level area, indicate whether to include bill-to, ship-to, or parent customers in the report. Parent includes bill-to customers and their respective ship-to customers in the report. The default value is Bill-To.
In the Show Costs area, indicate whether to include costs on the report, enter Y; otherwise, enter N.

Note: You must have either the COGS.VIEW or authorization key assigned to view costs.

In the Display Options area, Indicates what level of detail to print on the report.

Detail - Lists each transaction for each product.
Summary - Totals the transactions for each product.

In the Order Type area, indicate if the report should include, exclude, or print only the following order types:

Nonstocks - Defaults to Include.
Credits - Defaults to Include.
Bids - Defaults to Exclude.
Open Orders - Defaults to Include.

Set options, if needed, and generate the report.

If you use the Print or Hold menu options, depending on your authorization level, the system may prompt you to choose whether to view generic (commission) costs, cost of goods sold, or no costs on the report. Select an option to run the report.