Table of Contents

By Item

An item-centric view on inventory, to manage stock health item by item.

Analyse stock, value and movements per item or item group, use reach and turnover to spot overstocking and slow movers, and select an item to reveal its full supply-chain pattern of receipts and issues.

At a glance

Generated from the report definition (Item Movements / Item Movements).

  • Key visuals: line chart, lineStackedColumnComboChart, matrix

What this report helps you do

  • See on-hand quantity, value and item counts per item and item group
  • Use Reach (Days) to identify overstocked, slow-moving items
  • Reveal the receipt/issue supply-chain pattern for a selected item
  • Compare stock development year-over-year to detect shifts in demand

Filters & slicers

Filter What it does
Client, Period (relative), Period (year / month), Location, Item, Unit The same global slicers as the Summary page, applied to the item-level analysis.

Visuals on this page

KPI Summary Tiles

OnHand CostAmount Posted, OnHand Quantity, # Items OnHand, Reach (Days) and Turnover Rate (per Yr) for the selected items.

On-Hand / Stock Development

A line chart of OnHand Quantity and OnHand CostAmount Posted over time for the selected item(s).

  • Follow how an item's stock and value evolve together
  • Spot build-ups or depletions for specific items

Inventory Movements

A combined column/line chart of Quantity Receipt, Quantity Issue and on-hand Quantity per month, revealing the supply-chain pattern of a selected item.

  • See how receipts and issues drive an item's stock level
  • Identify irregular or seasonal replenishment patterns

Statistic by Item (Detail Table)

A table broken down by ItemCategory and Item with # Items OnHand, OnHand Quantity (and YoY %), OnHand CostAmount Posted (and YoY %), average on-hand quantity, Reach (Days), Turnover Rate (per Yr), Quantity Receipt and Quantity Issue.

  • Sort by Reach (Days) descending to detect items with the highest reach and identify overstockings
  • Rank items by turnover to separate fast and slow movers

Typical use cases

  • Overstock Detection — Sort the item table by Reach (Days) to surface items with excessive coverage and free up tied-up capital.
  • Item Supply-Chain Analysis — Select an item to inspect its receipts-vs-issues pattern and understand how it is replenished and consumed.
  • Item-Group Portfolio Review — Aggregate by item group to compare stock, value and turnover across categories and steer the assortment.
  • OnHand Quantity
  • OnHand CostAmount Posted
  • Reach (Days)
  • Turnover Rate (per Yr)
  • # Items OnHand

See the full KPI & measure catalog for definitions and formats.

Back to all Inventory standard reports · Semantic model · Key business questions

Edit this page