On-hand inventory at landed cost in Business Central. The working-capital line on the balance sheet.
At a glance
Total dollar value of on-hand inventory across every BC Location, valued at the configured Costing Method (typically FIFO, Average, or Standard). The working-capital line on the balance sheet.
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
An AU electronics manufacturer running Business Central with the Manufacturing module. Three Locations (Sydney warehouse, Melbourne retail, Drop-Ship from China). Snapshot 14 Apr 26.
Five things to notice:
- Sydney Warehouse holds 78% of the value. Standard pattern for a centralised distribution model. Pair with Inventory Aging to see how aged the Sydney stock is, and Top SKUs by Inventory Value to see which SKUs concentrate the value.
- Melbourne Retail has higher avg unit cost (14.20). Because the high-end consumer-grade SKUs are stocked in retail; bulk wholesale SKUs sit in Sydney. The Item.Costing Method = Average rolls these into a single Unit Cost which can mask the Location-level reality.
- In-Transit ($273K) is real working capital. The merchant has paid Chinese suppliers; the goods are on a vessel; until they land at Sydney they are not sellable but the cash has left. The Vortex IQ field map can split this out as its own row if Treasury wants visibility.
- **The BC Inventory Valuation report run for 14 Apr 26 shows 40 difference is rounding on the Adjust Cost batch, run earlier that morning. Acceptable variance.
- Manufacturing nuance: WIP (Work-in-Progress) is NOT in this card. WIP lives in
WIP InventoryG/L accounts, not Item Inventory. If the merchant wants to track total inventory + WIP for cash-conversion analysis, ask for the WIP-extended variant via the field map.
Sibling cards merchants should reference together
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Reports > Inventory > Inventory Valuation (the audit-grade definitive report) Item List > Calculate Inventory (real-time per-Item view) Chart of Accounts > Inventory G/L Account (balance, must reconcile to Inventory Valuation report) Power BI > Inventory Performance content pack > Inventory Value tileThe Inventory Valuation report run for the same date should match this card to within a few dollars. Differences > 0.1% indicate the Adjust Cost batch has not been run recently; the card uses the pre-Adjust-Cost rolling Unit Cost. Why our number may legitimately differ from BC’s reports:
Cross-connector reconciliation:
Known limitations / merchant FAQs
Why does my Inventory G/L balance not match this card? The G/L Inventory account is updated by the Adjust Cost - Item Entries batch, which most BC tenants run nightly. Between batch runs there is a small drift between the Item Ledger (real-time) and the G/L (post-batch). The card uses the Item Ledger view for freshness. To align, run Adjust Cost on demand and re-check. FIFO vs Average: which gives the more accurate “true” value? FIFO is closer to economic value during inflation (older, cheaper layers consumed first leaves higher-cost layers on hand). Average smooths volatility. The card respects whichever method each Item is configured for. If the merchant is changing methods, expect a one-time Inventory Valuation reset. Manufacturing tenants: where is WIP? WIP Inventory sits in dedicated G/L accounts (typically 1340 series) and is excluded from this card. Ask Vortex IQ for the WIP-extended variant if your finance team needs combined Inventory + WIP visibility. Does the card include items at vendor consignment? No. Consigned inventory is not owned by the merchant; it sits in the vendor’s books. BC’sItem Charge.Type = 'Consignment' flags it. The card excludes it.
Multi-Location: can I see per-Location breakdown?
Yes via the Top SKUs by Inventory Value sibling, which can be sliced by Location. The headline card aggregates.
How does this compare to NetSuite’s Total Inventory Value?
Mathematically equivalent. NetSuite uses Item Costing (FIFO / Average / LIFO / Standard) just like BC. The result for a merchant migrating from NetSuite to BC should be within rounding once Costing Methods align.
Does Power BI’s Inventory Performance content pack show the same number?
For one Company, yes. The Power BI tile uses the same Inventory Valuation report under the hood. Multi-Company tenants need to either build a custom Power BI roll-up or use this card.
FX impact on multi-Company total?
Each Company’s local-currency value is translated at current Currency Exchange Rate. Daily FX movement causes 0.5 to 2% intra-month wobble even with no inventory change. Some Treasurers prefer the period-end rate for a stable balance-sheet number; configurable.
Does this include Returns Inventory (RTV pending)?
Yes if the returned items are back in stock at a Location. If the items are flagged for write-off (no Location, marked for disposal), they are excluded.
AL Extension custom item attributes: do they affect the value?
No. Extensions can add fields and validations but the standard Costing Method engine governs valuation. As long as the extension does not override Item.Unit Cost, the card matches BC.