Running the Product Orders Report

This report lists all products that have been ordered during a designated period for the selected branches. It includes:

The customer that ordered them.
The order number.
The quantity ordered.
The quantity shipped.
The extended price.

To run the Product Orders Report:

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

In the Br/Tr/All field, enter the branch or territory to include in this report. To include all branches and territories, enter ALL.
In the Start Date field, enter the first date in a range of dates for which to view orders. This field supports variable dates.
In the End Date field, enter the last date in the range of dates for which to view orders. This field supports variable dates.

The system populates this field with the date entered in the Start Date field, but you can change it, if needed.

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 hot key to enter multiple values. Multi 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.
Customer Level	Indicates 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.
Show Costs (Y/N)	To include costs on the report, enter Y; otherwise, enter N. Note: You must have either the COGS.VIEW or COST.VIEW authorization key assigned to view costs.
Detail/Summary	Indicates what level of detail to print on the report. Detail – Lists each transaction for each product. Summary – Totals the transactions for each product.
Product Loc Qty Type	Selects products for the report based on their return status type, such as Stock or Defective.
Nonstocks (Inc/Exc/Only)	Indicates whether to include, exclude or run the report for nonstock orders only.
Credits (Inc/Exc/Only)	Indicates whether to include, exclude or run the report for credit orders only.
Bids (Inc/Exc/Only)	Indicates whether to include, exclude or run the report for bids only.
Open Orders (Inc/Exc/Only)	Indicates whether to include, exclude or run the report for open orders only.

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.