top of page

The Importance of Stock Keeping Units (SKUs) in Business Central for Accurate Replenishment

  • Writer: Kevin S. Jones, BC Manufacturing Consultant
    Kevin S. Jones, BC Manufacturing Consultant
  • Mar 31
  • 3 min read

Accurate replenishment is one of the most overlooked — and most costly — challenges in inventory management. In Microsoft Dynamics 365 Business Central, the key to solving this problem is often misunderstood or underused: Stock Keeping Units (SKUs).

This guide explains why SKUs are critical for accurate replenishment, how they differ from Item Cards, and — most importantly — how to set them up correctly in Business Central to support planning, purchasing, and manufacturing.

If you rely on Reorder Points, Safety Stock, MRP, or MPS, SKUs are not optional — they are essential.

What Is a Stock Keeping Unit (SKU) in Business Central?

In Business Central, a Stock Keeping Unit (SKU) allows you to define item‑specific planning, replenishment, and costing rules per location (and optionally per variant).

While the Item Card holds default values, the SKU overrides those values when stock exists at a specific location.

In simple terms:

  • Item Card = global defaults

  • SKU = local, operational reality

Business Central always uses the SKU values first when one exists.

Why SKUs Are Essential for Accurate Replenishment

1. Replenishment Is Location‑Specific — Items Are Not

Most businesses operate with:

  • Multiple warehouses

  • Quarantine or subcontract locations

  • Consignment or third‑party stock

  • Production and finished goods locations

Yet many still define reorder points and planning parameters only on the Item Card.

This leads to:

  • Overstock in one location

  • Stockouts in another

  • MRP suggesting incorrect purchase quantities

  • Planners losing trust in the system

SKUs solve this by allowing replenishment rules per location.

2. Business Central Planning Uses SKUs First

When Business Central runs:

  • Requisition Worksheets

  • Planning Worksheets (MRP/MPS)

  • Order Promising

  • Availability calculations

It follows this logic:

  1. Is an SKU defined for this Item + Location (+ Variant)?

  2. ✅ Yes → Use the SKU values

  3. ❌ No → Fall back to the Item Card

If you expect accurate results without SKUs, you are relying on a fallback mechanism — not proper planning.

3. Safety Stock and Reorder Points Only Work Properly with SKUs

A common mistake is defining:

  • Safety Stock Quantity

  • Reorder Point

  • Maximum Inventory

…on the Item Card, assuming they apply everywhere.

In reality:

  • Demand patterns vary by location

  • Lead times differ

  • Minimum order quantities change

  • Production vs distribution stock behaves differently

SKUs allow you to model this correctly, ensuring replenishment reflects how the business actually operates.

Common Symptoms of Missing or Poorly Configured SKUs

If any of these sound familiar, SKUs are likely the issue:

  • “MRP keeps suggesting the wrong quantities”

  • “We’re overstocked but still running out”

  • “Planning works in test but not in real life”

  • “The system ignores our reorder points”

  • “Buyers don’t trust Business Central suggestions”

These are planning data problems, not system limitations.

How to Set Up Stock Keeping Units Correctly in Business Central

Step 1: Decide Where SKUs Are Required

You do not need SKUs everywhere — but you do need them where behaviour differs.

Best practice is to create SKUs for:

  • Every stocked location

  • Every manufacturing location

  • Any location with unique lead times or reorder rules

  • Any location involved in MRP/MPS

Avoid SKUs for:

  • Non‑stock locations

  • Drop shipment–only scenarios

  • Service‑only items

Step 2: Create SKUs from the Item Card

From the Item Card:

  1. Select Related → Inventory → Stockkeeping Units

  2. Use Create Stockkeeping Unit

  3. Choose:

    • Location Code

    • Variant Code (if applicable)

This ensures consistency and avoids manual errors.

Step 3: Define Replenishment Parameters on the SKU

On each SKU, define:

  • Replenishment System

    • Purchase

    • Prod. Order

    • Transfer

  • Reorder Point

  • Safety Stock Quantity

  • Maximum Inventory

  • Lot Accumulation Period

  • Minimum Order Quantity

  • Lead Time Calculation

These values are what Business Central actually uses for planning.

Step 4: Align SKUs with Manufacturing Strategy

For manufacturing environments:

  • Use SKUs to separate:

    • Make‑to‑Stock locations

    • Make‑to‑Order locations

  • Control:

    • Dampener periods

    • Rescheduling flexibility

    • Transfer vs production replenishment

This prevents MRP from creating noise and unstable production plans.

Step 5: Review and Maintain SKUs Regularly

SKUs are not set‑and‑forget.

Review them when:

  • Demand changes

  • Lead times increase

  • New suppliers are introduced

  • Warehouses are restructured

Out‑of‑date SKUs are one of the biggest causes of planning failure.

SKUs and Replenishment Accuracy: The Real Business Impact

When SKUs are set up correctly, businesses typically see:

  • Reduced inventory holding

  • Fewer emergency purchases

  • More stable MRP results

  • Improved service levels

  • Higher trust in Business Central planning

In short: SKUs turn Business Central from a transactional system into a planning system.

Final Thoughts: SKUs Are Not Optional

If you are serious about:

  • Accurate replenishment

  • Reliable MRP/MPS

  • Scalable inventory management

Then Stock Keeping Units must be part of your Business Central design.

Most replenishment issues blamed on “MRP not working” are actually SKU design issues.

Get the SKUs right — and planning starts to work.

Want to Improve Your Replenishment Setup?

If you’d like:

  • A SKU design review

  • Replenishment parameter templates

  • Manufacturing‑specific planning guidance

This is exactly the kind of problem we help businesses solve.

 
 
 

Comments


bottom of page