ABC analysis and slow-moving items in Business Central

Inventory is never uniform — some items drive most of the revenue and warrant tight control; others are dead weight tying up capital. ABC analysis and slow-moving inventory identification are the analytical lenses that separate which is which. Business Central includes both natively; the operational actions that follow are what produce the business value.

ABC analysis — the principle. The classic Pareto observation: typically 80% of revenue (or value) comes from 20% of SKUs. Inventory management benefits from segmenting accordingly:

• A-class items — ~10–20% of SKUs, ~70–80% of value. Tight control: weekly cycle counts, low safety stock, frequent supplier relationships, narrow reorder windows.
• B-class items — ~30–40% of SKUs, ~15–20% of value. Standard control: monthly counting, moderate safety stock, regular reordering.
• C-class items — ~50–60% of SKUs, ~5–10% of value. Loose control: annual counting, larger safety stock, infrequent reordering, possibly Min/Max replenishment.

ABC analysis in Business Central. The platform supports ABC analysis through:

• Item statistics — sales and consumption data per item over a period.
• ABC analysis report — segments items by chosen criteria (revenue, gross profit, units sold, cost) into A / B / C tiers based on configurable percentages.
• Item classification field — store the ABC class on each item card; routines can update it periodically.

Configuration of the analysis. Choose:

• Period — last 12 months, last quarter, year-to-date. Longer periods smooth noise; shorter periods reflect recent shifts.
• Criterion — by sales value, by cost value, by gross profit, by units sold. Different criteria produce different segmentations.
• Tier thresholds — A = top 80%, B = next 15%, C = remaining 5% (configurable).
• Scope — all items, by item category, by location.

Acting on ABC classifications. The classification itself does nothing; the operational actions that follow create value:

• A items: counting periods set to weekly. Safety stock reviewed quarterly. Supplier diversification considered (single-supplier risk on A items is high). Reorder points tight to minimise capital while avoiding stockouts.
• B items: standard treatment. Mid-frequency cycle counting. Moderate safety stock.
• C items: loose treatment. Annual counting. Larger safety stock (cost of holding is low; cost of stockout is also low for slow movers).

Slow-moving inventory. Beyond ABC, identifying items that aren't moving is critical. Slow movers consume warehouse space, tie up capital, become obsolete, and eventually require write-downs.

Slow-moving identification. Business Central reports surface:

• Items with no sales in N days / months — pure no-movement.
• Items with declining velocity — selling, but at slower and slower rates.
• Items with high inventory days on hand — substantial stock relative to demand.
• Items past expected sell-through date (configurable).

Generated reports list candidates; the inventory team reviews and acts.

Inventory ageing. A complementary view: how long has inventory been sitting? Items can be old in two ways:

• Lot ageing — the lot is approaching expiry. Action: prioritise pick or initiate write-off.
• Receipt ageing — items received N months ago and still on hand. Action: investigate why; possibly markdown, return to vendor, write off.

For perishable items (food, pharma, chemicals), receipt ageing is a daily operational concern; lot ageing drives picking priorities (FEFO — first-expired-first-out).

Actions on slow movers.

• Markdown — reduce price to clear. The slow-moving discount is a sales-team-and-finance decision.
• Bundle — combine slow movers with fast-movers in promotional bundles.
• Return to vendor — for vendor-returnable items, return for credit before they become unsalvageable.
• Write off — for items beyond hope, write off to inventory adjustment.
• Discontinue — block from purchase; sell down inventory then retire.
• Move to satellite locations — sometimes slow movers in one location are normal-pace elsewhere; reallocate.

Reporting. Pre-built reports cover ABC analysis, slow-moving inventory, inventory ageing. Power BI dashboards extend with cross-cutting analysis — slow movers by customer segment, by supplier, by item category.

Common pitfalls.

• No classification routine — ABC analysis runs once at implementation and never updates. Market dynamics shift; classifications go stale.
• Slow movers ignored — reports surface them; nobody acts. Capital accumulates indefinitely.
• Wrong period for ABC — using last-12-months for a fast-changing fashion business hides recent reality.
• Markdowns without strategy — random discounting that erodes margin without clearing inventory.

Operational discipline. Run ABC analysis quarterly. Review slow movers monthly. Action — actually adjust safety stock, counting periods, supplier discussions, markdowns. Without action, the analysis is just reports.