The single headline number for total on-hand inventory value at cost, with a per-warehouse drill underneath.
At a glance
The total current value of on-hand inventory, valued at cost, across every warehouse and legal entity, presented as one executive KPI number with a per-warehouse drill. This is the headline version of the by-warehouse bar card: the one figure a finance leader checks to answer “how much cash is sitting in stock right now”, with the per-site split one click away.
| What it counts | Total on-hand inventory value at cost. Conceptually SUM(on-hand quantity x unit cost) across all warehouses and sites, rolled up to a single number. In Finance & Operations this draws on the inventory transaction layer (InventTrans / on-hand store, the AvailablePhysical concept) and the per-item costing method. In Business Central the equivalent is Item Ledger Entry plus Value Entry. The drill regroups the same total by Warehouse / Location. |
| Costing basis | At cost, not retail. Uses the item’s configured costing method per legal entity (standard, FIFO, weighted average, or moving average). The list / sell price is never used. |
| Currency | Reported in the dashboard reporting currency. Each legal entity’s on-hand value is translated from its accounting currency at the period FX rate before the headline number is summed. |
| Multi-Company / legal entity | Respects the selected legal-entity (Company) filter. By default rolls up every entity the connected Azure AD identity can see, so the headline can span warehouses across multiple countries and currencies. |
| Time window | RT (real time, current on-hand snapshot) |
| Alert trigger | Not applicable. This is a descriptive KPI headline with no drop / spike alert. |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A multi-entity outdoor-equipment brand running Finance & Operations across UK and US legal entities, snapshot taken 20 Mar 26, reporting currency GBP, all values at cost. The headline tile reads one number; the drill expands to the per-warehouse split.| Drill line | Legal entity | On-hand value (GBP) | Share |
|---|---|---|---|
| MAIN-DC | UK Outdoor Ltd | £2,210,000 | 51.2% |
| OVERFLOW-DC | UK Outdoor Ltd | £640,000 | 14.8% |
| US-EAST-DC | US Outdoor Inc | £880,000 | 20.4% |
| US-WEST-DC | US Outdoor Inc | £318,000 | 7.4% |
| TRANSIT (in transit) | both | £268,000 | 6.2% |
| On-Hand Inventory Value (headline) | £4,316,000 | 100% |
- The headline is one number: £4,316,000. That is the figure a CFO or owner glances at to gauge how much working capital is tied up in stock. The drill exists for when the answer prompts the next question, “where”.
- 6.2% of the value is in transit. The TRANSIT line is stock that has shipped from one site but not yet been received at another. It is real on-hand value the business owns, but it is not sellable from any DC right now. If you only ever look at the headline, remember it includes transit; the by-warehouse bar card makes the transit slice obvious.
- The two US warehouses translate via FX. US-EAST-DC and US-WEST-DC are held in USD and translated to GBP at the 20 Mar 26 rate. A dollar move shifts the headline with no physical change, so week-on-week wobble is not always a stock movement.
- This is the same data as the by-warehouse card, presented differently. This card leads with the total and offers the split on drill; Inventory Value by Warehouse leads with the bars. Use this one for the board slide and that one for the operations review.
Sibling cards merchants should reference together
On-Hand Inventory Value is the headline working-capital-in-stock number. Pair it with these to understand the composition and the cost.| Card | Why pair it with On-Hand Inventory Value |
|---|---|
| Inventory Value by Warehouse | The bar-chart breakdown of this exact total. This card is the headline KPI; that card is the per-site distribution. Read them as a pair. |
| Total Inventory Value | The broader all-stock valuation. Use it to confirm the headline ties to the company-wide figure once you account for warehouse inclusion filters. |
| Inventory Carrying Cost | Converts this stock value into an ongoing cash cost. A high headline here drives a high carrying cost there. |
| Dead Stock Value | Tells you how much of this headline is not actually moving. A large total that hides a large dead slice is a markdown problem. |
| Inventory Aging | The freshness profile behind the headline. A flat total can mask ageing stock if new receipts replace old ones at the same value. |
Reconciling against Microsoft Dynamics 365
Where to look in Business Central / Finance & Operations: The closest native equivalents in the Dynamics UI are:F&O > Cost management > Inventory accounting > Inventory value report (the audit-grade total valuation) F&O > Inventory management > Inquiries and reports > On-hand inventory (current on-hand, can be grouped by Warehouse) Business Central > Reports > Inventory Valuation (BC’s costed total, the audit reference) Business Central > Inventory > Item Availability by Location (the per-Location drill in BC)Run the Inventory value report (F&O) or Inventory Valuation report (BC) for the same snapshot date and the same legal entities. The grand total should match this headline to within rounding. The per-warehouse breakdown should match the drill. Common mistakes when comparing against the native reports:
- Physical vs financial on-hand. The on-hand inquiry shows AvailablePhysical; the value report uses the financially updated cost layer. Receipts posted physically but not financially appear in one before the other.
- Wrong costing date. The value report is as-of a chosen date. Compare like for like with the card snapshot date.
- Default warehouse exclusions. Native reports may exclude transit / non-nettable warehouses. This headline includes them unless you filter, so it can read higher.
| Reason | Direction | Why |
|---|---|---|
| Physical vs financial posting lag | Either | The card reads the live on-hand layer; the value report uses financially updated cost. A receipt posted physically but not financially shows in one and not the other until close or recalculation. |
| Costing not yet settled | Either | FIFO and average-cost items settle true cost at inventory close. Between closes the headline uses a running estimate and can drift from the post-close total. |
| Local vs reporting currency | Either | The headline translates each entity to the reporting currency at the period FX rate. A native report in a single entity’s currency differs by the FX translation. Match the scope. |
| Transit / non-nettable inclusion | Card usually higher | This headline includes transit and quarantine warehouses by default; many native reports exclude them. |
| Sync cache lag | Card a few minutes behind | The on-hand layer is read on a short cache; a just-posted movement can hit F&O before the card refreshes. |