Print Product Performance Reports (PPPR)

Purpose: Use the Product Performance Report (Ordered Totals) and Product Performance Report (Shipped Totals) to review total quantities and dollar values of items ordered or shipped for a range of dates, as well as current inventory status.

Totals not net of returns, cancels, soldouts, or after-shipment discounts: The shipped totals on the Product Performance Report (Shipped Totals) do not reflect any returns that have been processed against the items. For example, if there have been 100 units of an item shipped, and 15 returned, the quantity shipped on the report is 100, not 85.

Similarly, the ordered totals on the Product Performance Report (Ordered Totals) does not reflect any quantities sold out or canceled (unless you use a cancel reason flagged to reduce demand). If there have been 200 units of an item ordered, and 7 sold out, the ordered total is 200, not 193.

Also, the dollar totals do not reflect any discounts applied after shipment using the Discount option in order maintenance. For example, you shipped 10 units for an extended price of $200.00. Afterward, you applied a discount of 10% in order to preserve customer satisfaction because of an issue related to the order. The Merch dollars shipped total on the report is still $200.00 and does not reflect the 10% discount.

Component items not included: The report includes the set master item rather than its components. Items that are components of sets are included on the report only if they were ordered or shipped as stand-alone items. See Working with Sets for background on working with set items.

Quotes excluded: This report excludes quotes, identified by the Quote flag on the order type on the order. See Entering Pre-Order Quotes for an overview.

In this chapter:

• Product Performance Reports Screen

• Product Performance Report (Ordered Totals)

• Product Performance Report (Shipped Totals)

Product Performance Reports Screen

How to display this screen: Enter PPPR in the Fast path field at the top of any menu, or select Print Product Performance Reports from a menu.

Field	Description
Start Date	Enter the first order or shipment date to include on the report. The report includes items that have been ordered (based on the order’s Entered date) or shipped on or after this date. The start date must be on or earlier than the current date and the end date. Numeric, 6 positions (in user date format); required.
End Date	Enter the last order or shipment date to include on the report. The report includes items that have been ordered (based on the order’s Entered date) or shipped on or before this date. The end date must be on or earlier than the current date and no earlier than the start date. Numeric, 6 positions (in user date format); required.
Report Option	Indicate whether the report should include total units and dollars ordered or shipped, and how to sort the report: • Ordered Product Performance by Ascending Items = Generate the Product Performance Report (Ordered Totals) in alphanumeric order by item code • Ordered Product Performance by Descending Total Dollars = Generate the Product Performance Report (Ordered Totals) listing items beginning with the item/SKU with the highest Merchandise Dollars Ordered for the selected date range and descending to the item/SKU with the lowest Merchandise Dollars Ordered • Ordered Product Performance by Order Type = Generates the Product Performance Report (Ordered Totals) listing items sorted first by the order type on which they were ordered, and then in alphanumeric order by item code • Shipped Product Performance by Ascending Items = Generate the Product Performance Report (Shipped Totals) in alphanumeric order by item code • Shipped Product Performance by Descending Total Dollars = Generate the Product Performance Report (Shipped Totals) listing items beginning with the item/SKU with the highest Merchandise Dollars Shipped for the selected date range and descending to the item/SKU with the lowest Merchandise Dollars Shipped • Shipped Product Performance by Order Type = Generates the Product Performance Report (Shipped Totals) listing items sorted first by the order type on which they were ordered and shipped, and then in descending order by shipped quantity

Completing this screen: Complete all fields as described above and select Print Report to submit the PROD_PERFF job, which generates the Product Performance Report (Ordered Totals) or the Product Performance Report (Shipped Totals).