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‑to‑day processes (consumption & output, subcontracting, rework)
  • Month‑end close (adjust cost, reconcile, analyze variances)
  • Reporting & troubleshooting

2) Costing in Business Central: the moving parts

2.1 Item costing methods

Choose the right one per item:

  • Standard: Fixed standard cost with variances captured (recommended for discrete manufacturing).
  • FIFO / Average: Actual flow/average; fewer variances but volatile margins.
  • Specific: Lot/serial specific; niche use.

Tip: For manufactured SKUs with repeatability, Standard is best. Use a Standard Cost Worksheet for roll‑ups and updates.

2.2 Capacity & overhead costs (work/machine centers)

Work and machine centers capture time‑based costs during production:

  • Direct Unit Cost: Cost per time unit (e.g., per hour).
  • Indirect Cost %: Markup applied on top of direct cost to cover indirects.
  • Overhead Rate: Fixed surcharge per time unit (alternative to %).

These feed Capacity Ledger Entries when you post Output and Setup/Run time, and are capital to WIP and finished cost.

2.3 BOMs, Routings & Cost Roll‑ups

  • Production BOM: Material list and quantities. Drives Item Ledger entries and material cost.
  • Routing: Sequence of operations with work/machine centers, setup/run times, scrap, etc. Drives Capacity Ledger entries and capacity cost.
  • Cost Roll‑up: From components (BOM) + operations (routing rates) → Unit cost on the parent item.

2.4 Posting & WIP

  • Production postings hit Item Ledger Entries (materials & output) and Capacity Ledger Entries (time), with parallel Value Entries.
  • WIP & Finished Goods go to G/L via Inventory Posting Setup and General Posting Setup.
  • Two key jobs keep costs accurate: Adjust Cost – Item Entries and Post Inventory Cost to G/L.

2.5 Variances (Standard Costing)

With Standard costing, differences land in variance accounts:

  • Material variance (qty/price)
  • Capacity variance (time/rate)
  • Subcontracting variance
  • Overhead variance
  • Purchase variance (for purchased parts)

3) Prerequisites & master data

3.1 Company‑wide setup

  • General Ledger Setup → Enable expected costs (optional, recommended).
  • Inventory Setup → Automatic Cost Posting (on), Expected Cost Posting (optional), Automatic Cost Adjustment (Daily or Always, per policy).
  • Manufacturing Setup → Define rounding, flushing defaults, shop calendar, etc.

3.2 Posting groups (critical)

  • General Product Posting Group & Gen. Bus. Posting Group → map COGS/Revenue.
  • Inventory Posting Group → map Inventory & WIP accounts by Location.
  • Item Posting Groups → used on items to hit correct inventory/WIP.
  • Manufacturing Overhead/Variance accounts → set in Inventory Posting Setup and Manufacturing related posting.
  • Create distinct G/L accounts for: WIP (materials), WIP (capacity), Finished Goods, Material Variance, Capacity Variance, Overhead Variance, Subcontracting, etc.

3.3 Work Centers & Machine Centers

For each Work Center (e.g., Assembly, Paint, CNC):

  • Unit of Measure: HOURS (typical)
  • Direct Unit Cost: e.g., 40.00/hr
  • Indirect Cost %: e.g., 15% (covers supervision, consumables)
  • Overhead Rate (optional): e.g., 5.00/hr
  • Efficiency / Capacity: affects planned time but not cost per hour; cost uses posted time × rate.
  • Shop Calendar Code: drives capacity availability.

For each Machine Center under a Work Center:

  • Can hold its own direct cost and overhead %/rate; otherwise inherit from its Work Center.

3.4 Items

  • Costing Method: Standard/FIFO/Average/Specific.
  • Standard Cost: maintained via Standard Cost Worksheet (for Standard items).
  • Item Posting Group, Gen. Prod. Posting Group: to hit the right G/L accounts.
  • Flushing Method: Manual, Backward, Forward (per operation or per component).

3.5 BOMs & Routings

  • Production BOM: Components, UOMs, scrap %.
  • Routing: Operations, Work/Machine Center, Setup Time, Run Time (per unit or lot), Wait/Move, Scrap %.
  • Keep routings realistic: if run time is per piece, indicate time per unit; if per batch, use lot size fields.

4) Minimum viable costing setup (step‑by‑step)

  1. Create posting groups & G/L accounts
    • WIP (Material), WIP (Capacity), Finished Goods, Material Variance, Capacity Variance, Overhead Variance, Subcontracting, Purchase Variance, etc.
    • Configure Inventory Posting Setup for each Location × Item Posting Group.
  2. Define Work Centers (and Machine Centers as needed)
    • Set Direct Unit Cost, Indirect Cost % or Overhead Rate.
    • Assign Calendar and Capacity (for planning) and ensure Unit of Measure = HOURS.
  3. Set up Items
    • Choose Standard for manufactured parents (recommended).
    • Assign Posting Groups and default Flushing Method (e.g., Backward for output‑driven consumption).
  4. Build Production BOMs & Routings
    • Ensure each routing operation points to the correct Work/Machine Center and has realistic times.
  5. Run a Cost Roll‑up (for Standard‑cost items)
    • Use Standard Cost Worksheet → Suggest Item Standard Cost → Review → Implement Standard Cost Changes.
    • This updates Standard Cost on items and can revalue inventory if set.
  6. Test with a Pilot Production Order
    • Create a Released order for 1–10 units.
    • Post Consumption & Output with realistic times.
    • Review Item Ledger, Value Entries, Capacity Ledger for results.

5) Allocating cost to Work Centers & Items

5.1 How allocation works (mechanics)

When you post Output (and optionally Setup/Run time), BC:

  • Writes Capacity Ledger Entries with Time × (Direct Unit Cost + Overhead) for the Work/Machine Center.
  • Capitalizes that cost into WIP (until you finish) and ultimately into Finished Goods (at output completion), or records as variance under Standard costing.

When you post Consumption, BC:

  • Writes Item Ledger consumption for BOM components at their cost (Standard or actual), capitalized to WIP.
  • Finally, Output of the parent item moves WIP into the parent’s cost (finished inventory) and later into COGS on sale.

5.2 Setting Work Center rates

On each Work Center Card:

  • Direct Unit Cost = fully burdened direct rate you want absorbed (e.g., wages + benefits per productive hour).
  • Choose Indirect Cost % or Overhead Rate to absorb indirects (factory utilities, depreciation, etc.).

Example: Direct 40.00/hr + Indirect 20% → Effective 48.00/hr. Two hours posted → 96.00 capacity cost.

You can mix at Machine Center level if certain machines are more expensive.

5.3 Driving time capture

  • Backflushing: Post time automatically from routing; faster, less accurate.
  • Manual time: Operators post actual times via Output Journal/Production Journal or MES integration; most accurate.

5.4 Rolling capacity cost into item cost

  • For Standard items, maintain realistic routing times and rates. Run Standard Cost Worksheet roll‑up to calculate operation costs per unit (Setup amortized by lot size + Run time × rate). Implement changes to update item Standard Cost.
  • For FIFO/Average items, capacity cost posts as actuals per order and becomes part of the finished item’s cost at completion.

5.5 Overheads via Cost Categories (optional)

If you use Cost Accounting or dimensions, map Work Centers to cost centers and track absorbed vs actual by dimension. See §9.

6) Day‑to‑day manufacturing posting

6.1 Consumption

Methods:

  • Production Journal → enter component quantities (or backflush via flushing method).
  • Consumption Journal → bulk issue materials; link to order.

Make sure lots/serials and scrap are recorded. Over‑consumption drives material variances under Standard.

6.2 Output & time

  • Output Journal → quantity produced, output date, Run Time/Setup Time, scrap.
  • Posting creates Capacity Ledger Entries for the selected Work/Machine Center and pushes costs to WIP/Finished.

6.3 Subcontracting

Create a Work Center flagged for Subcontracting or handle via Purchase Orders linked to the operation. The subcontracted service cost posts as part of the production order cost (and variance if Standard vs actual differs).

6.4 Rework & Non‑conforming

Use a separate Routing step or dedicated Work Center for rework. Assign higher rates if desired to highlight cost of quality.

7) Month‑end close (must‑do)

  1. Review unposted journals (Consumption/Output) → post or reverse.
  2. Run Adjust Cost – Item Entries to propagate last‑minute costs and finalize roll‑ups.
  3. Run Post Inventory Cost to G/L to push Value Entries to the G/L (choose date filters).
  4. Reconcile WIP: Use WIP reports & Production Order Statistics to verify WIP balances per order. Ensure partially finished orders carry correct WIP (materials + capacity).
  5. Analyze variances (Standard costing): Item → Statistics, Production Order → Statistics for material/capacity/overhead variances.
  6. Revalue inventory (if needed): Revaluation Journal for purchased/finished items when standards change mid‑period.

8) Example: Setting rates & allocating to a Work Center

Scenario: Assembly Work Center with:

  • Direct Unit Cost = 30.00/hr
  • Indirect Cost % = 25%
  • Routing Operation: Setup = 0.5 hr per lot, Run = 0.1 hr per piece, Lot Size = 50

Per‑unit absorbed capacity:

  • Setup per unit = 0.5 / 50 = 0.01 hr
  • Run per unit = 0.10 hr
  • Total time = 0.11 hr × Effective Rate (30 × 1.25 = 37.50) = 4.13 per unit

During production, if actual run time posted is higher (say 0.14 hr/unit), the extra 0.03 hr/unit appears as Capacity Variance under Standard costing.

9) Dimensions & cost centers (linking Work Centers to the P&L)

Use Global Dimensions such as Department = Cost Center. On Work Center Card:

  • Assign Default Dimension (e.g., Department = ASSEMBLY).
  • Capacity costs posted will carry this dimension, letting you analyze absorption by cost center.
  • For materials, use Item or Item Category dimension mapping to see material spend by product family.

Reports:

  • G/L by dimensions

    • Dimensions – Total (Report 27): Pick Analysis View, set Date Filter and Column Layout → run totals by dimension hierarchy.

    • Dimensions – Detail (Report 28): same view, entry-level G/L detail.

  • Inventory/Items by dimensions

    • Item Dimensions – Total (Report 7151): totals of item activity (Quantity / Cost Amount / Sales Amount) by dimensions.

    • Item Dimensions – Detail (Report 7150): value-entry level breakdown by dimensions.

  • Matrix analysis

    • Analysis Views → Analysis by Dimensions: choose rows/columns dimensions → Show Matrix → drill into entries.

  • Month-end (costing)

    • Adjust Cost – Item Entries → Post Inventory Cost to G/L (Report 1002) (run the Test variant first to catch skipped entries).

10) Subcontracting best practices

  • Create a Subcontracting Work Center with zero time if you only capture vendor cost via Purchase Order; or give it a nominal rate to track internal handling.
  • Use Purchase Orders linked to the production order operation; the receipt posts cost to the order.
  • Separate G/L accounts for subcontracting cost and variance.

11) Flushing strategies

  • Backward flushing (at output): simple, but hides timing errors; good for high‑volume stable processes.
  • Forward flushing (at release): issues materials when starting; risk of over‑issuance if the order changes.
  • Manual: most control and accuracy; best where variances matter.
  • You can mix per component and per operation.

12) Variances — how to read them

  • Material qty variance: BOM inaccurate, scrap higher, or backflush not aligned.
  • Material price variance: Purchase price differs from standard.
  • Capacity variance: Time posted vs routing/std differs (method or rate issue).
  • Overhead variance: Applied overhead vs absorbed differs (rates/volumes off).
  • Subcontracting variance: Vendor invoice differs from expected.

Investigate via Production Order → Statistics and Capacity Ledger Entries drill‑downs.

13) Month‑end checklist (quick reference)

  • Unposted journals cleared
  • Adjust Cost – Item Entries run
  • Post Inventory Cost to G/L run
  • WIP reconciled to Production Orders
  • Variances reviewed and explained
  • Revaluations (if any) posted
  • Reports archived (Valuation, WIP, P&L by dimension)

14) Reporting & analytics

  • Item Ledger Entries / Value Entries: per‑transaction costs.
  • Capacity Ledger Entries: time & cost by Work/Machine Center.
  • Production Order Statistics: planned vs actual cost and variances.
  • Inventory Valuation & WIP Reports: period‑end views.
  • G/L by Dimension: absorbed vs actual by cost center.
  • Consider Power BI over Value Entries and Capacity Ledger for cost‑per‑work‑center dashboards.

15) Troubleshooting: common pitfalls

  • Missing rates on Work/Machine Centers → zero capacity cost; fix Direct Unit Cost / Overhead.
  • Routing times unrealistic → skewed capacity absorption; re‑time and re‑roll‑up.
  • No Adjust Cost run → finished costs incomplete; always run before reporting.
  • Wrong posting groups → costs in wrong G/L; verify Inventory Posting Setup & Gen. Posting.
  • Flushing mismatch → component over/under issue; align method with reality.
  • Dimensions missing → no cost center view; set default dimensions on Work Centers and Items.

16) Implementation blueprint (project plan)

  1. Design: Define cost objects (items, work centers), costing methods, overhead policy.
  2. Chart of Accounts & Posting Groups: Create WIP/variance/FG accounts and map.
  3. Master Data: Items, BOMs, Routings, Work/Machine Centers with rates.
  4. Pilot: One product family; dry‑run a full order lifecycle.
  5. Controls: Journals, approvals, time capture process, month‑end SOP.
  6. Reporting: Dimensions, Power BI, standard reports.
  7. Rollout: Train operators and finance; move to all families.

17) Quick setup reference (field cheat‑sheet)

Work Center Card

  • Direct Unit Cost | Indirect Cost % | Overhead Rate | Unit of Measure | Calendar | Efficiency | Default Dimensions

Machine Center Card

  • (Overrides) Direct Unit Cost | Indirect % | Overhead Rate | Unit of Measure | Calendar

Routing Line

  • Operation No. | Work/Machine Center | Setup Time | Run Time | Time Unit | Lot Size | Scrap % | Flushing Method

Item Card

  • Costing Method | Standard Cost | Item Posting Group | Gen. Prod. Posting Group | Flushing | Item Category | Dimensions

Posting

  • Inventory Posting Setup | Gen. Posting Setup | Inventory Setup | Manufacturing Setup

 

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