> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # 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. **Card class:** [Non-Hero](/nerve-centre/overview#card-classes-explained) • **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type) > 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](/nerve-centre/kpi-cards/microsoft-dynamics/inventory-value-by-warehouse) 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](/nerve-centre/kpi-cards/microsoft-dynamics/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](/nerve-centre/kpi-cards/microsoft-dynamics/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](/nerve-centre/kpi-cards/microsoft-dynamics/msd-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](/nerve-centre/kpi-cards/microsoft-dynamics/msd-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](/nerve-centre/kpi-cards/microsoft-dynamics/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](/nerve-centre/kpi-cards/microsoft-dynamics/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 %](/nerve-centre/kpi-cards/microsoft-dynamics/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)](/nerve-centre/kpi-cards/microsoft-dynamics/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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.