Standard costing is attractive because it gives finance a stable number to plan and report against. It is also unforgiving: the roll-up is only as good as the four inputs feeding it, and when one of them is incomplete the result still looks like a valid cost. Nothing errors out — a finished good simply rolls up low, and margin reporting is wrong until someone notices.

This page covers the setup itself: which cost types exist, where the roll-up takes each component from, how work center rates and overhead rules are applied, and the specific gaps that produce wrong numbers. If the open question is whether to move from average costing to standard at all, that decision is covered in a separate three-part series linked below — this page assumes the decision is made.

Talk to a Senior Sage X3 Consultant

Signs the roll-up is not trustworthy

Roll-up returns zero or implausibly low costs for certain finished goods
Overhead applied twice on some products and missing entirely on others
Standard cost differing between sites with no intended reason
Large purchase or production variances appearing every single period
A roll-up run for the wrong cost type or period that overwrote a valid standard

The concepts the roll-up depends on

Cost types

Standard cost, revised standard cost, budget cost, and simulated cost each exist per product-site and per period or version in the product cost table, ITMCOST. A roll-up is always run for a specific cost type and validity period, which is why running the wrong combination can overwrite a standard that finance has already signed off.

Material cost basis

For purchased items the roll-up takes the cost from the product-site cost record of the chosen type — not from average cost unless the setup deliberately brings it in. A purchased component with no standard cost for that period rolls up as zero and silently understates its parent.

Bill of material

The roll-up uses the production BOM code and alternative valid on the calculation date. Component quantities, scrap percentages, and link quantities all feed the material cost, so a BOM maintained for planning rather than costing will produce a costing surprise.

Routing and work center rates

Operations, work centers, setup and run times, and the hourly labor and machine rates on each work center produce the labor and machine components. A work center rate left at zero, or defined only for one site, is one of the commonest reasons a cost looks too low.

Overhead rules

Overheads are applied through formulas and rules keyed on cost category or product ranges, as a percentage or an amount per unit. Rules keyed on statistical groups or category ranges are the usual explanation for "why does this product get different overhead than that one" — and for overhead applied twice when two rules match the same item.

Multi-level roll-up order

Sub-assemblies must roll before their parents. The run order, together with the choice to recalculate lower levels, determines whether parents pick up fresh child costs or stale ones from a previous cycle.

What actually goes wrong

Purchased components with no standard cost for the period or the site being rolled
A roll-up run against the wrong BOM alternative, or a BOM not valid on the calculation date
Work center rates left at zero, or maintained only for the primary site
Overlapping overhead formulas matching the same product, or rules referencing a field that is blank on part of the catalogue
Unit-of-measure mismatches between BOM component units and stock units
Site-specific BOM, routing, or cost data missing on a secondary site
A standard changed mid-period on a product valued at standard, producing a revaluation variance nobody had planned for

A setup sequence that holds up

1. Agree the costing policy first
Decide which products are valued at standard and which at average, and how often standards are refreshed. An annual standard with revised standard for interim changes is a common and workable pattern.
2. Load purchased-item costs per site and period
Populate standard costs for every purchased component in scope and verify there are no zeros left. This single check prevents most understated parents.
3. Validate BOMs and routings on a sample
Take representative products from each product family and confirm the BOM alternative, validity dates, component units, and routing operations are what costing should be using.
4. Define and prove work center rates and overhead rules
Set labor and machine rates per site, then test each overhead rule against a representative product and confirm the expected breakdown across material, labor, machine, and overhead.
5. Run a simulated roll-up before the live one
Roll the simulated cost type first and compare the results against expected costs and against current valuation. Investigate every outlier before running the live standard.
6. Plan the accounting impact
For products valued at standard, changing the standard revalues stock on hand and posts a variance. Agree that impact with finance ahead of the run rather than explaining it afterwards.
7. Document the procedure and the run order
Write down which cost types are rolled, in what order, with which options, and who approves the result. Undocumented roll-up procedures are the first thing lost to staff turnover.

Deciding whether to convert from average to standard

Setting standard costing up correctly is a different problem from deciding whether to adopt it. If your organization is weighing the change — or is partway through one and seeing variances it cannot explain — we cover that decision and its execution risks in a three-part series.

When a roll-up problem needs outside eyes

Overheads behaving inconsistently across product ranges
Multiple sites with different rates and different local practices
Variances that finance genuinely cannot explain period after period
A move from average to standard costing, or back the other way
A roll-up procedure that was never documented and the person who knew it has left

PRH designs and audits overhead rule structures — including query-level audits comparing calculated cost components against expected values — rolls standard costing out across multiple sites, and works through variance analysis alongside finance so the numbers are defensible in a board pack, not just inside the ERP.

Standard costing questions

How does Sage X3 calculate standard cost?

By rolling up BOM material cost, routing labor and machine time valued at work center rates, and overhead rules — held per product-site for a specific cost type and period.

What is the difference between standard cost and revised standard cost?

Revised standard is an interim standard used to update costs during the year without replacing the annual standard. Which one values your stock depends on the valuation method set on the product-site.

Why does my standard cost roll-up show zero for some products?

Usually a purchased component with no cost for that period or site, or a BOM or routing that was not valid on the calculation date.

Why are overheads wrong on some products?

Overlapping or mis-keyed overhead rules. Audit which rule each affected product actually matches before adjusting any rates.

Does changing standard cost revalue inventory?

For products valued at standard, yes — the difference posts as a revaluation variance, which is why the change should be planned with finance.

Can I use standard cost at one site and average at another?

Yes. Valuation method is defined per product-site, so mixed approaches across sites are supported, provided transfers between them are understood.

Sage X3 Standard Cost Setup and Roll-Up