APICS to Business Central: A Hands-On Reference for Senior Consultants

A technical, field-ready reference that maps APICS concepts (ERP, MPS, MRP, CRP, SFC) to Microsoft Dynamics 365 Business Central with step-by-step configuration, field-level guidance, and diagram placement cues."

Senior ERP consultants need precise clicks, field meanings, and explainable system behaviour—not anecdotes. This guide connects the APICS planning hierarchy to Microsoft Dynamics 365 Business Central (BC) in a purely procedural style. The flow follows ERP → MPS → MRP → CRP → SFC. For each concept you will find: the APICS framing, the business purpose, where BC implements it, exact configuration steps with menu paths, integration notes, and a diagram placement cue. No illustrative scenarios are included.

ERP (Enterprise Resource Planning)

1) APICS definition & framework

ERP is the integrated backbone that unifies planning (S&OP, MPS, MRP, CRP) and execution (SFC) with finance, inventory, and cost accounting. It provides a single data model for items, BOMs, routings, lead times, capacity, orders, and postings.

2) Business purpose

Create one version of the truth so that commitments are feasible in materials and capacity and accurately costed in the G/L. Remove spreadsheet islands, standardize planning signals, and connect operational events to financial results.

3) Business Central implementation

  • Master data: Items, SKUs, Production BOMs, Routings, Work/Machine Centers, Calendars, Vendors, Locations.
  • Planning surfaces: Planning Worksheet (MPS/MRP), Requisition Worksheet (purchasing), Order Planning (order-by-order).
  • Execution surfaces: Production Orders (Simulated → Planned → Firm Planned → Released → Finished), Consumption/Output/Production Journals, Item/Value/Capacity Ledger Entries.
  • Global switches: Inventory Setup (Planning), Manufacturing Setup (e.g., Components at Location, low-level code behaviour).

Navigation

  • Tell Me (Alt+Q) → search the exact page name (e.g., Items, Production BOMs, Routings, Planning Worksheet, Inventory Setup, Manufacturing Setup).
  • Classic: Departments → Manufacturing → Planning → Planning Worksheet.

4) Step-by-step configuration

  1. Calendars
    • Tell Me → Base Calendars → define working days and exceptions.
    • Assign to Vendors and Work/Machine Centers as appropriate.
  2. Items / SKUs
    • Tell Me → Items → open an item → Planning FastTab:
      • Replenishment System (Production Order / Purchase / Assembly / Transfer)
      • Reordering Policy (Lot-for-Lot / Fixed Reorder Qty. / Maximum Qty. / Order)
      • Safety Stock Quantity, Safety Lead Time
      • Lead Time Calculation
      • Time Bucket, Lot Accumulation Period, Order Multiple
      • Rescheduling Period, Dampener Period, Dampener Quantity %
      • Planning Flexibility (None / Unlimited)
    • Tell Me → Stockkeeping Units to override planning by Location and Variant (e.g., Components at Location).
  3. BOMs & Routings
    • Tell Me → Production BOMs → maintain component lines; Status = Certified.
    • Tell Me → Routings → define operations, link to centers, set Setup/Run/Move/Wait/Queue times; Status = Certified.
  4. Global planning settings
    • Tell Me → Inventory Setup → Planning: set Current Demand Forecast, Default Dampener Period/Quantity, Default Safety Lead Time, Use Forecast on Locations/Variants, Combined MPS/MRP Calculation.
    • Tell Me → Manufacturing Setup: review Components at Location, low-level code calculation options.

5) Integration points

A single set of master records drives all planning layers; postings from SFC update inventory and finance and feed back into availability for subsequent plans.

7) Diagram placement

Insert diagram: ERP integration map—Forecast/S&OP → MPS → MRP → CRP → SFC, with postings to Item/Value/Capacity ledgers and G/L.

MPS (Master Production Schedule)

1) APICS definition & framework

MPS is the time-phased plan for end items (or key families), netting forecasts with actual orders and stabilising near-term production via fences (Frozen/Slushy/Liquid).

2) Business purpose

Stabilise the shop by defining what will be built when at the finished-goods level. Reduce nervousness and provide a credible signal to purchasing and subassemblies.

3) Business Central implementation

  • Page: Planning Worksheet
  • Function: Calculate Plan with MPS enabled (optionally include Forecast; optionally combine with MRP)
  • Tools: Pegging/Order Tracking, Accept/Carry Out Action Message, Firm Planned orders for near-term buckets.

Navigation

  • Tell Me → Planning Worksheet → Actions → Functions → Calculate Plan.

4) Step-by-step configuration

  1. Create a Demand Forecast
    • Tell Me → Demand Forecasts → New → set Name and View by (e.g., Week/Month).
    • Optionally enable location/variant-specific forecasting in Inventory Setup → Planning.
  2. Tune item planning fields
    • Choose a Reordering Policy suitable for end items (often Lot-for-Lot).
    • Use Time Bucket and Lot Accumulation Period to smooth demand.
    • Configure Rescheduling Period and Dampener Period/Quantity to curb micro-changes.
  3. Run MPS
    • Planning Worksheet → Calculate Plan: set MPS = Yes (and Include Forecast as needed).
    • Set Starting/Ending Dates, No. filters (end items), and Location filters.
  4. Firm the near term
    • Use Accept and Carry Out to create Firm Planned receipts in the Frozen/Slushy windows.

5) Integration points

MPS drives end-item receipts that MRP later explodes to components; CRP validates feasibility; SFC executes released orders.

7) Diagram placement

Insert diagram: MPS weekly timeline as lines with Frozen/Slushy/Liquid fences and a firming window.

MRP (Material Requirements Planning)

1) APICS definition & framework

MRP explodes the MPS and other demand through the multi-level BOM, nets against on-hand and scheduled receipts (plus safety), time-phases by lead times, and proposes New, Reschedule, Change, or Cancel supplies.

2) Business purpose

Ensure the right components and raw materials arrive precisely when needed, minimizing shortages and excess, and aligning purchasing and subassembly production with the master plan.

3) Business Central implementation

  • Page: Planning Worksheet
  • Function: Calculate Plan with MRP enabled (optionally with MPS).
  • Tools: Pegging/Order Tracking, action messages, Carry Out Action Message to create POs and (Firm Planned) Production Orders.
  • Data drivers: Certified Production BOMs and Routings determine explosion and timing; Lead Time Calculation and Flushing methods shape dates and postings.

Navigation

  • Tell Me → Planning Worksheet → Actions → Functions → Calculate Plan.

4) Step-by-step configuration

  1. Verify BOMs
    • Confirm component lists, quantities, and Status = Certified in Production BOMs.
  2. Check replenishment and lead times
    • On component items, set Replenishment System (make/buy), Lead Time Calculation, Order Multiple, Safety, and Rescheduling/Dampener parameters.
  3. Run MRP
    • In Calculate Plan, set MRP = Yes (and MPS = Yes if running both).
    • Filter by No. and Location as appropriate; include forecast if applicable.
  4. Review pegging and action messages
    • Use Order Tracking to trace supply proposals back to causes; approve New, Change Qty., Resched., or Cancel.
  5. Carry out
    • Carry Out Action Msg. – Plan to create purchase and production orders.

5) Integration points

MRP results feed CRP (capacity validation) and SFC once orders move past planning. Dampeners, time buckets, and rescheduling windows align the material plan with operational cadence.

7) Diagram placement

Insert diagram: MRP netting/explosion flow (Demand → Net Requirements → Planned Orders) with a small pegging tree.

CRP (Capacity Requirements Planning)

1) APICS definition & framework

CRP compares required hours (from planned/firm/released orders and routings) to available hours (from calendars, capacities, efficiencies) per work/machine center and time bucket.

2) Business purpose

Prevent infeasible schedules by identifying overloads early so planners can move, split, or add capacity before orders reach the floor.

3) Business Central implementation

  • Capacity model: Work Centers (aggregate) and Machine Centers (individual).
  • Finite control: Capacity Constrained Resources allows bottleneck flagging with Critical Load % and Dampener so planning shifts loads away from overfull buckets.
  • Views: Work Center Load, Machine Center Load, calendars, and capacity entries.

Navigation

  • Tell Me → Work Centers, Machine Centers, Capacity Constrained Resources, Work Center Load.

4) Step-by-step configuration

  1. Work/Machine Centers
    • Define No. of Resources, Efficiency, Base Calendar, Queue/Move/Wait times, and costing (Direct Unit Cost, Indirect %, Overhead Rate).
  2. Routing fidelity
    • Maintain realistic Setup/Run times, Routing Lot Size, and Routing Link Codes that drive time and overlap.
  3. Finite rules
    • Tell Me → Capacity Constrained Resources → flag bottlenecks; set Critical Load % and Dampener.
  4. Validate after planning
    • After Carry Out, open Work Center Load; adjust dates, split lots, or temporarily increase capacity.

5) Integration points

CRP confirms MPS/MRP feasibility. If overloaded, update the plan (move or split) before release to SFC.

7) Diagram placement

Insert diagram: CRP load vs available hours per week for a bottleneck center with annotations for overload and corrective actions.

SFC (Shop Floor Control)

1) APICS definition & framework

SFC executes the plan by releasing orders, issuing materials, recording output and time (including scrap), and finishing orders—posting to inventory, WIP, and variance accounts.

2) Business purpose

Turn plan into fact. Ensure availability and costs reflect reality and that accurate feedback informs the next planning cycle.

3) Business Central implementation

  • Order statuses: Simulated → Planned → Firm Planned → Released → Finished.
  • Posting options: Production Journal (combined consumption + output) or dedicated Consumption and Output journals.
  • Flushing: Manual, Forward (at release), Backward (at finish), By Operation Output.

Navigation

  • Tell Me → Production Orders, Production Journal, Consumption Journal, Output Journal.

4) Step-by-step execution

  1. Release
    • Change production order Status to Released.
  2. Pick/Consume
    • Use Production Journal (or Consumption Journal) to issue components; leverage Flushing Method to automate where appropriate.
  3. Output & Time
    • Record Output Quantity, Run/Setup Time, and Scrap at each operation; post to generate Item/Capacity Ledger Entries.
  4. Finish
    • Change Status to Finished to close WIP and post remaining flushes and variances.
  5. Audit
    • Use Navigate and Item/Value/Capacity Ledger Entries to verify postings.

5) Integration points

Posted output/time updates availability and capacity utilisation, which the next MPS/MRP run uses; WIP and variances feed finance.

7) Diagram placement

Insert diagram: SFC flow—Release → Pick/Consume → Output/Time → Ledgers/WIP → Finish → availability feedback to planning.

Field-Level Reference (Planning Levers)

Item Card → Planning FastTab

  • Replenishment System: Production Order (make), Purchase (buy), Assembly (assemble-to-order), Transfer (move).
  • Reordering Policy:
    • Lot-for-Lot — one supply per net bucket; reduces inventory tails and nervousness at FG level.
    • Fixed Reorder Qty. — batch with Reorder Quantity; good for purchased high-runners.
    • Maximum Qty. — refill to a cap; consider for min/max replenishment.
    • Order — one supply per demand line.
  • Safety Stock Quantity / Safety Lead Time: quantity vs time buffers.
  • Lead Time Calculation: procurement/manufacturing offset (supports D, W, M, H notation).
  • Time Bucket / Lot Accumulation Period: grouping horizon; use to avoid day-to-day plan churn.
  • Order Multiple: rounds proposals to purchase pack/MOQ.
  • Rescheduling Period: horizon in which the planner prefers move over cancel/new.
  • Dampener Period & Quantity %: suppress small expedite/defer and minor lot changes.
  • Planning Flexibility: None protects existing supplies; Unlimited allows automatic updates.

Inventory Setup → Planning

  • Current Demand Forecast, Use Forecast on Locations/Variants, Default Dampener Period/Quantity %, Default Safety Lead Time, Combined MPS/MRP Calculation.

Manufacturing Setup

  • Components at Location (default pick site for components), low-level code calculation behaviour.

Capacity and Calendars

  • Work/Machine Centers: capacity, efficiency, calendar, costing.
  • Capacity Constrained Resources: mark only true bottlenecks; set Critical Load %/Dampener.

Planning Desks

  • Planning Worksheet: multi-level manufacturing planning (MPS/MRP), pegging, explosion, action messages, Carry Out.
  • Requisition Worksheet: purchasing-centric replenishment without full manufacturing explosion.
  • Order Planning: order-by-order replenishment.

Implementation Sequencing

  1. Master data first
    • Items/Units, Production BOMs (Certified), Routings (Certified), Work/Machine Centers, Base Calendars.
  2. Planning parameters
    • On Items/SKUs: set policies, lead times, time buckets, dampener/rescheduling windows.
  3. Forecast & MPS
    • Create a Demand Forecast; run MPS only; firm the near term (Frozen window).
  4. MRP
    • Run MPS+MRP; act on New/Resched/Change/Cancel; Carry Out to create POs and subassembly orders.
  5. CRP
    • Validate load vs capacity; if finite rules are on, allow BC to push loads off overloads; otherwise, move/split manually.
  6. SFC
    • Release, consume, output, finish; verify ledgers and variances.

Common Pitfalls and How to Avoid Them

  • Uncertified BOMs/Routings → planning ignores them. Always Certified before runs.
  • No time buckets → daily nervousness. Use Time Bucket and Lot Accumulation Period for smoothing.
  • Over-firming → poor responsiveness. Firm only the Frozen window.
  • Wrong component site → mismatched Components at Location or SKU setup.
  • Endless expediting → tune Rescheduling Period, Dampener Period/Quantity, and Lead Times.
  • Finite everywhere → twitchy plans and performance issues. Constrain only true bottlenecks.
  • Late shop postings → stale availability and variances. Establish a daily posting cadence and audit with Navigate.

Planning Worksheet vs Requisition Worksheet

  • Planning Worksheet: multi-level manufacturing planning with MPS/MRP, pegging, explosion, action messages; creates production and purchase proposals. Use for plant-wide planning cycles.
  • Requisition Worksheet: purchasing focus; use when buyers alone need proposals for buy items without full manufacturing context.

 

Comments

Post a Comment

Popular posts from this blog

Understanding Database Indexes in Business Central (and How They Can Help You)

Image
When I first started working with Business Central, the word “indexes” felt too technical for me — like something only developers or database admins cared about. But then I discovered the Database Missing Indexes page . At first, I thought it listed all the indexes that exist in the database. Later, I realized it’s even more interesting: it actually shows the indexes that don’t exist yet, but SQL thinks should be there . That page became a game-changer for me in understanding why some reports and pages are slow, and how I can help point my team toward performance fixes. What Are Indexes, Anyway?  Indexes are like shortcuts. Imagine a giant cookbook with 1,000 recipes. If I want to find every recipe with “chicken,” I don’t flip through each page — I go to the index in the back. Databases work the same way. If I filter a table by Posting Date , an index lets the system jump straight to those rows instead of scanning everything. When no index exists for the filter, the system has to ...
Read more
Image
Dynamics 365 Business Central · Manufacturing · APICS/ASCM Business Central & APICS/ASCM for Manufacturers: A Practical, No‑Nonsense Guide for Consultants, IT Leaders, and Plant Managers By Grigorios Mavrogeorgis · Approx. 15–20 min read Who this is for Business Central consultants who need precise setup guidance. IT decision-makers evaluating ERP fit for manufacturing. Manufacturing managers who want to understand how BC will run their shop—today, not in theory. Table of contents APICS (now ASCM): What It Is and Why It Matters How Closely Business Central Aligns to APICS/ASCM The Three Primary Manufacturing Types—With Real Examples Configuring Business Central for Each Manufacturing Type JIT Manufacturing: Principles and Benefits Implementing JIT in Business Central: A Step‑by‑Step Blueprint End-to-End Configuration Recipes Practical Navigation & Setup Pointers Key Takeaways References 1) APICS (now ASCM): What It Is and Why It Matters APICS...
Read more
  Business Central Costing for Manufacturing — User Manual   Applies to: Microsoft Dynamics 365 Business Central (SaaS & On‑Prem). Screens and labels may vary slightly by version. The concepts are stable across recent versions. Suggested Blogger Labels: Business Central, Dynamics 365, Manufacturing, Costing, Standard Costing, FIFO, Average Costing, Work Centers, Machine Centers, WIP, Variances, Subcontracting, Month-end Close, Reporting 1) What this guide covers A practical, end‑to‑end playbook for setting up costing in Business Central (BC) for manufacturing and allocating costs to work centers and items. It includes: Costing concepts in BC (item costs, capacity costs, overheads, variances) Master data you need (Items, BOMs, Routings, Work/Machine Centers) The minimum viable setup for accurate costing How to allocate costs to work centers and roll them into item costs Posting flows, WIP, and G/L integration Day‑...
Read more