JJC SystemsBook a Consultation
Dynamics 365 Business Central · Advanced

Configuring actual costing in Business Central.

Move quoting off a stale standard and onto real production cost, without disrupting the month end you have to close next week.

Who this is for

Two summaries, because two audiences read this

If you own the outcome

Your quoted margin is only as good as the cost basis behind it. This guide shows what changes operationally when you move to actual costing, what it costs to get there, and why we recommend running both models in parallel for a full quarter before switching.

If you have to build it

Costing method selection, work centre and machine centre rate setup, capacity posting, WIP and variance account mapping, and the inventory adjustment run that reconciles it all. Assumes you already have production orders posting cleanly.

Why it matters

The problem this solves

Standard costing is not wrong. It is a deliberate simplification that trades accuracy for stability, and it works well when standards are reviewed regularly. Most mid-market manufacturers do not review them regularly, so the simplification quietly becomes a distortion.

The business consequence is that quoting, product rationalisation and customer profitability decisions are all made on a number nobody has validated recently. The variance analysis exists, but it arrives after the quarter and explains rather than informs.

Before you start

Prerequisites

Check these before beginning. Most stalled implementations stall on one of them.

Licensing

Business Central Premium. Manufacturing and Service Management are Premium-only; Essentials will not carry production orders.

Roles

Business Central administrator, plus a finance owner who can approve the account mapping and a production planner who knows the routings.

Data

Bills of material and routings that reflect what actually happens on the floor. If routings are aspirational, fix them first — costing amplifies routing errors.

Baseline

One closed, signed-off period you can reconcile the new model against.

How it works

The concepts worth understanding first

Configuration is straightforward once these are clear. Skipping them is why most first attempts produce something that works and cannot be maintained.

Costing methods are per item, not per company

Business Central sets the costing method on the item card, so you can run Standard on stable purchased components and Average or FIFO on manufactured items without converting everything. This matters — it means the migration can be staged by item category rather than attempted as a single event.

Capacity cost comes from work and machine centres

Direct and indirect cost rates are set on the work centre and machine centre. When an operation is posted against a production order, capacity cost flows at those rates. If the rates are stale the actual cost is no more accurate than the standard was, so rate review is part of the work rather than a follow-up.

Adjust Cost — Item Entries is what closes the loop

This batch job propagates cost changes through the value entry chain. Until it runs, inventory valuation and COGS reflect expected cost rather than actual. Scheduling it — and knowing how long it takes on your data volume — is the operational detail most implementations underestimate.

Configuration

Step by step

Settings shown are the ones that matter, not every field on the form. Values are starting points to validate against your own environment.

01

Set the costing method by item category

Start with manufactured finished goods rather than components. Open the item card, set Costing Method, and note that the method cannot be changed once value entries exist without an inventory revaluation.

Purchased components with stable pricing can stay on Standard. This is a legitimate mixed model, not a compromise.

Costing Method
Average or FIFO for manufactured items; Standard is acceptable for stable purchased components
Standard Cost
Retain the existing value during the parallel period for reporting continuity
Item Category
Use categories to stage the migration by group rather than item by item
02

Review work centre and machine centre rates

Direct Unit Cost carries labour; Indirect Cost % and Overhead Rate carry the burden. Getting these approximately right matters more than getting them precisely right, because the alternative is a machine rate set when the equipment was installed.

Where a work centre covers several genuinely different operations, split it. A single blended rate across dissimilar work is the most common source of unexplainable variance.

Direct Unit Cost
Labour rate per unit of measure — verify against current payroll, not the rate in the field
Indirect Cost %
Burden applied as a percentage of direct cost
Overhead Rate
Fixed overhead per unit of time, where you allocate that way
Unit Cost Calculation
Time or Units, matched to how the operation is actually measured
03

Map the variance and WIP accounts

Inventory Posting Setup and General Posting Setup control where variance lands. Get this agreed with finance before posting anything, because unpicking misposted variance across a period is genuinely unpleasant.

Separate the variance accounts by type. A single combined variance account tells you that something moved and nothing about why.

WIP Account
Per inventory posting group, so work in progress is visible by product family
Material Variance
Separated from capacity variance
Capacity Variance
Separated again into capacity and capacity overhead where volumes justify it
Subcontracted Variance
Distinct account if you subcontract operations
04

Enable capacity posting and expected cost posting

Manufacturing Setup controls whether capacity is posted automatically when operations are finished. Expected Cost Posting in Inventory Setup determines whether interim values reach the general ledger before invoicing.

Turning on expected cost posting gives finance visibility during the period, which is the point of the exercise. It also increases posting volume, so test the performance impact on a copy of production first.

Automatic Cost Posting
On — otherwise the ledger lags inventory continuously
Expected Cost Posting to G/L
On, so in-period WIP is visible
Automatic Cost Adjustment
Set to Day or Week; Always is heavy on larger datasets
Average Cost Calc. Type
Item, unless you genuinely need location or variant granularity
05

Run the parallel quarter

Post production normally. Let both the standard and the actual roll accumulate. At period end, compare by product family rather than by part — family-level patterns are where the commercial decisions are.

The reconciliation test is the one that matters: can the new model reproduce a period you have already closed and signed off? If not, the configuration is not finished.

Verify it worked

  1. Run Adjust Cost — Item Entries and confirm it completes within your close window on production-sized data.
  2. Reconcile Inventory Valuation against the general ledger inventory accounts for a closed period.
  3. Pick three finished items and trace unit cost back through the value entries to material, capacity and subcontract components.
  4. Compare actual against standard by product family and confirm the variance is explainable rather than merely present.
  5. Confirm WIP by inventory posting group reconciles to the WIP account balance.
Best practice

What we do on every engagement of this type

  • Stage by item category rather than converting the whole item master at once
  • Split work centres that cover genuinely different operations before setting rates
  • Separate material, capacity and subcontract variance accounts from the start
  • Schedule the cost adjustment run and monitor its duration as data volume grows
  • Keep the standard cost populated during the parallel period for reporting continuity
  • Review capacity rates on a defined cycle — annually at minimum — or you recreate the original problem
Pitfalls

What catches most first attempts

Every one of these is avoidable, and every one of them is common enough that we check for it by default.

!Changing costing method after value entries exist

Business Central will not simply switch it. You need an inventory revaluation, and doing this mid-period on live data creates reconciliation work nobody enjoys. Decide the method per category before you post.

!Leaving Automatic Cost Adjustment on Always

It is tempting because it keeps everything current. On a manufacturer with real transaction volume it makes posting noticeably slower. Day or Week is almost always the right setting.

!Blended work centre rates

One rate covering a manual assembly bench and a CNC cell produces variance that cannot be explained and therefore will not be acted on. Split the work centre.

!Skipping the routing review

Actual costing does not fix inaccurate routings; it makes them visible as variance. If the routings describe an idealised process, correct them before you switch or you will spend the parallel quarter investigating the wrong thing.

Completion checklist

  • Costing method decided per item category and documented
  • Work centre and machine centre rates reviewed against current payroll and overhead
  • Variance accounts separated by type and agreed with finance
  • Expected cost posting and automatic cost adjustment configured and performance-tested
  • One closed period reconciled successfully in the new model
  • Parallel quarter scheduled with a defined comparison and decision point

Want a second pair of eyes?

If you want the reconciliation done against your own data before committing, send us a chart of accounts, an item list and one closed period. We will configure a demo environment and run the comparison with your controller.

Request a consultation See our Dynamics 365 Business Central page We reply to every message within one business day.
Get In Touch

Tell us what you're trying to fix

Describe the situation in your own words.

Please enter your first name.
Please enter your last name.
Please enter a valid email address.
Please enter your company name.
Please choose an option.
Please add a short description.

We reply to every message within one business day.