Skip to main content
Card class: Card

At a glance

Top 10 Items by current Inventory Value. Pareto check: typically 5% of SKUs hold 60% of inventory value.
What it countsItem.Inventory × Item.Unit Cost ranked descending, top 10.
CurrencyReporting Currency.
Time windowRT
Rolesowner, 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

US distributor on BC, snapshot 14 Apr 26.
RankSKUOn-handInventory Value (USD)
1ELEC-LAPTOP-A141,820$828K
2ELEC-MONITOR-27940$480K
3ELEC-DOCK-USB41,140$384K
4-10(others)$1.42M
Top 10**3.11Mof3.11M** of 5.4M total = 58%

Sibling cards merchants should reference together

CardWhy pair
Total Inventory ValueTotal denominator.
Inventory AgingAre top SKUs aging?
Margin by SKUProfitability of top SKUs.
Dead Stock with Active Ad SpendTop SKU on dead-list = big recovery.

Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Item List > Sort by Inventory Value descending Reports > Inventory > ABC Analysis
Why may differ:
ReasonDirectionWhy
Multi-Company aggregationCard sums across
OData freshnessCard 15 min behind
Cross-connector reconciliation: shopify.top_inventory_skus for retail price view (different denominator).

Known limitations / merchant FAQs

Healthy concentration? ABC analysis: A (top 5%) holds 60-80% of value, B (next 15%) holds 15-25%, C (bottom 80%) holds 5-15%. Top 10 vs Top 25? Default 10; configurable. Multi-Location: per-Location ranking? Aggregated by Item No. across Locations by default; per-Location available.

Tracked live in Vortex IQ Nerve Centre

Top SKUs by Inventory Value 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.