Skip to main content

What this page is for

Inventory metrics per product is the report you live in when you’re triaging your catalog. Every product (SKU) gets a row, and each row expands to per-warehouse detail so you can see where the stock actually sits. It gathers sales history, forecast, values, stock position, and coverage into one place so you can sort, filter, and act on the products that need you. Think of it as your product-level worklist: scan it, sort by what matters today, filter to the products in trouble, and open the ones that need a decision.

The columns

Columns are selectable — turn on the ones you need. They fall into a few groups:
GroupColumnsWhat they tell you
IdentityProduct, Internal title, ABCWhich product it is, plus its ABC class (A = your most important movers, C = the least).
Sales historyOrders in last 30 / 60 / 90 days, Avg/day for eachHow much has actually sold recently, and the daily run rate.
ForecastNext-30-day forecast, avg/dayExpected demand for the coming month.
ValuesOverstock value, Inventory valueDollars tied up in excess, and total dollars on hand.
Stock positionStock on-hand, Open orders, Available, Available after pending B2B, InboundWhat you have, what’s already ordered, what’s truly free to use, and what’s coming.
CoverageCoverage, Coverage with InboundHow long today’s stock lasts, without and with incoming orders.
Available after pending B2B subtracts stock earmarked for pending business-to-business orders, so you see what’s genuinely uncommitted. Coverage with Inbound extends the runway to include orders already on the way.

Reorder status

Every product is also classified into a reorder status — a triage bucket you can filter on to jump straight to the products in a given state:
StatusWhat it means
Out of stockNothing available now.
Will run out of stockProjected to hit zero within the horizon.
Replenish nowTime to reorder to stay ahead of demand.
All goodHealthy — no action needed.
OverstockMore than you need.
Filtering to Out of stock and Replenish now gives you your action list for the day; Overstock gives you what to slow down or transfer.

Digging into the numbers

The Inbound and Open orders figures have popovers that break down the incoming quantity by source — which purchase orders (POs), transfer orders (TOs), and work orders (WOs) make up the total. So when a product shows healthy Inbound, you can open it and confirm exactly which orders you’re counting on and when they land.

Step by step: build your daily action list

  1. Filter reorder status to Replenish now and Will run out of stock.
  2. Sort by ABC or Inventory value so your most important products rise to the top.
  3. For a tight product, open the Inbound popover to see which POs, TOs, or WOs are coming and when.
  4. Expand the row to per-warehouse detail to see which location is short.
  5. Act on the shortfall, then move to the next product.

Example

A planner filters to Replenish now, sorts by ABC, and lands on an A-class SKU showing Available well under its next-30-day forecast. The Inbound popover shows one PO arriving too late. Expanding the row reveals the East warehouse is the one running dry. The planner expedites the PO and moves on.
Tip: This report is the bridge from the aggregate to the action. Come here from the Planning overview, and save the column layout and filters you use most as a reusable preset — see Custom views and Supply planning.