Table of Contents

By Location

A location-centric view on inventory, to balance stock across warehouses and sites.

Break stock and value down by inventory location, compare movements and on-hand development per site, and use the detailed table to see exactly how much of each item sits where.

At a glance

Generated from the report definition (Locations / Locations).

  • Key visuals: line chart, lineStackedColumnComboChart, matrix

What this report helps you do

  • See how on-hand quantity and value are distributed across locations
  • Focus movements and stock development on a single selected location
  • Compare reach and turnover between sites to rebalance stock
  • Spot locations with over- or under-stocked items using the detail table

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 location-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 locations.

On-Hand / Stock Development

A line chart of OnHand Quantity and OnHand CostAmount Posted over time that reacts to the selected location(s).

  • See how stock and value develop for a chosen location
  • Compare a location's trajectory against the overall picture

Inventory Movements

A combined column/line chart of Quantity Receipt, Quantity Issue and on-hand Quantity per month for the selected location(s).

  • Understand inbound vs. outbound flows at a specific site
  • Identify locations with imbalanced movements

Statistic by Location (Detail Table)

A table broken down by InventLocation 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 or turnover to find over- or under-stocked items per location
  • Compare year-over-year stock development across sites

Typical use cases

  • Location Stock Balancing — Compare on-hand quantity, value and reach across sites to rebalance stock and reduce local overstocking or shortages.
  • Single-Location Deep Dive — Select one location to focus the movement and stock-development charts and understand its specific inventory behaviour.
  • Multi-Site Performance Comparison — Use the detail table to rank locations and items by turnover, reach and value for targeted action.
  • OnHand Quantity
  • OnHand CostAmount Posted
  • # Items OnHand
  • Reach (Days)
  • Turnover Rate (per Yr)

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

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

Edit this page