Returned Products Report

The Returned Products Report tracks the top ten returned products by quantity for a given time span.

A purchasing manager or shipment manager may need to assess and evaluate the performance of suppliers, products, and sellers in terms of the number of returns received.

The Returned Products Report provides visibility into the ten most frequently returned items for an enterprise within a specific period of time, based on quantity. This report includes items from non-draft return orders that are not service items.

This report does not filter for UOM or unit price. Therefore, if multiple items have the same item identifier and description, but different UOMs, the items are treated as the same item and the sum of the units sold for all of them is used. Likewise, if multiple items have the same item identifier and description, but different unit prices, the average unit price is used.

If multiple items have the same number of returns within the specified time period, this report can list more than 10 items.

The Returned Products Report should be run at night, during a period of light load.

Figure 1 shows a sample of the Returned Products Report.

Figure 1. Sample Returned Products Report
A sample report displaying returned products by item ID.

This report also presents the reasons for the return, and the percentage of returns for each reason. Click the Item ID link to see the reason code and percentage of returns for that reason in the Return Reasons per Product Report. Figure 2 shows a sample of the Return Reason per Product Report.

Figure 2. Sample Return Reasons per Product Report
A sample return reason per product report with a pie graph and a table.
Note: The sample reports provided are designed to be run with low data volumes.