Inventory Top 10 List (report)

The Inventory Top 10 List report lists the items with the highest or lowest sales within a selected period. You can exclude items that aren't in inventory or weren't sold.

Choose whether to rank by Sales (LCY) or Inventory, and whether to show the largest or smallest amounts. Use Quantity to set how many items to include. The report doesn't rank items by the number of units sold.

Use this report when you plan your purchasing.

Available layouts

INTRODUCED IN: Business Central 2026 release wave 1.

The report includes an Excel layout with worksheets designed for print and for analysis.

You can export the layout from the Report Layouts page, edit it in Excel to cater for your needs, and import it back to Business Central. Learn more in Creating your own report layouts.

Use cases

Review the highest or lowest selling items based on sales amounts over a selected period, or rank items by inventory quantity, to assist with purchase planning.

Purchasing managers use the report to:

  • Review the highest selling items over the selected period and ensure adequate stock.
  • Identify low-selling items to reduce inventory costs.
  • Plan for future purchases based on the sales history of specific items.

Sales managers use the report to:

  • Identify the highest selling items over a selected period to focus sales efforts.
  • Determine which items aren't selling well and require more marketing.
  • Monitor the sales performance of specific items over time.

Warehouse supervisors use the report to:

  • Monitor the inventory levels of the highest selling items.
  • Plan for incoming and outgoing shipments based on the sales history of specific items.
  • Identify items that require extra storage space based on their sales performance.

Financial analysts use the report to:

  • Compare sales amounts in local currency for items over a selected period.
  • Compare the selected items with the report totals. The report doesn't calculate profit or cost of goods sold.
  • Identify trends and patterns in the sales performance of specific items.

Try the report

Try the report here: Inventory Top 10 List

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview

Find free e-learning modules for Business Central here