On-Hand Inventory Value (by Warehouse), Microsoft Dynamics 365

On-Hand Inventory Value (by Warehouse) is the headline total stock value at cost, with a per-warehouse drill. How to read it, why it matters, and how to act on it.

Metrics type: Supporting Metrics • Category: Ecommerce Platform

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%

Four things to notice:

1. 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”.
2. 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.
3. 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.
4. 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.

Why our number may legitimately differ:

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.

Cross-connector note: This headline is the ERP truth for inventory value. Your commerce platform tracks only sellable quantity it has been told about, which can diverge from F&O / BC. When the two disagree at SKU level, start at the ERP-vs-Ecom Inventory Variance % gauge.

Known limitations / merchant FAQs

Why is there both this card and Inventory Value by Warehouse? This card is the executive single-number headline; the other is the per-warehouse bar breakdown. They use the same underlying data. The split exists so a board slide can show one clean figure while an operations review can drill into the distribution without cluttering the headline.

Is the headline at cost or at sellable value? At cost, using each item’s configured costing method per legal entity. It is the working-capital-in-stock figure, not what the stock would sell for.

Does the headline include in-transit stock? Yes by default. Stock that has shipped from one site and not yet been received at another is still inventory the business owns, so it counts. If you want sellable-from-a-DC value only, filter out transit warehouses.

Why does the headline move when I did not buy or sell anything? FX translation of non-reporting-currency warehouses, and costing revaluation on FIFO / average items as new receipts post at different unit costs. Either can move the number with the physical count unchanged.

How fresh is the headline? It reads the on-hand layer on a short cache, so it is current to within a few minutes of the last posted movement, materially fresher than a scheduled report refresh.

Does it net out negative on-hand? Yes. If a warehouse has gone negative on-hand it reduces the total. Persistent negatives are a data-quality issue rather than a real valuation and are tracked on Inventory On-Hand Went Negative (any warehouse).

Single-entity accounts: any difference? Same logic, simpler scope. One legal entity means no FX translation and no consolidation; the headline is simply the local-currency total.

---

Tracked live in Vortex IQ Nerve Centre

On-Hand Inventory Value (by Warehouse) is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

Start for free or book a demo to see this metric running on your own data.