Top 10 Products Report

Marketing and merchandising personnel make catalog and promotional decisions based on the most popular products sold, and inventory analysts track products to anticipate their shelf life.

The Top 10 Products Report provides visibility into the 10 most frequently purchased products within a specified time period. The 10 products included in a non-draft sales order within a specific time period, that are not service products and have the highest ordered quantity, are included in this report.

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 quantity sold within the specified time period, this report can list more than 10 items.

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

The following image shows a sample of the Top 10 Products Report.

Figure 1. Sample Top 10 Products Report
A table displaying a sample report of the Top 10 products that are sold, including how many units have been sold.
Note:
  • The sample reports provided are designed to run with low data volumes.
  • The sample reports are designed to run for a 7-day period or lesser but not beyond 7 days