Infor SyteLine4 min readNetray Engineering TeamUpdated March 4, 2025

How to Fix SyteLine Cost Rollup Variances

Cost rollup variances in SyteLine create inaccurate standard costs that flow into inventory valuation, COGS calculations, and margin analysis. These variances arise from outdated BOM structures, incorrect routing labor rates, misconfigured overhead allocation, and timing mismatches between cost rollup execution and actual parameter updates. This guide provides a systematic approach to identifying variance sources, validating cost components, and executing clean cost rollups that produce accurate standard costs.

Identifying Cost Variance Sources with SQL Diagnostics

Start by comparing current standard costs against the pending rolled-up costs using the Cost Comparison report or a direct query: SELECT i.item, i.unit_cost AS current_std, cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost AS rolled_cost, ABS(i.unit_cost - (cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost)) AS variance FROM dbo.item i JOIN dbo.cost_rollup cr ON i.item = cr.item WHERE ABS(i.unit_cost - (cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost)) > 0.01. Filter for variances exceeding your materiality threshold, typically 5% or $1.00 per unit. Drill into the cost_rollup table to see the breakdown by material, labor, fixed overhead, and variable overhead to isolate which cost element is driving the variance.

Run cost comparison query joining item and cost_rollup tables to identify items with variances exceeding $1.00
Break down variance by cost element: material (matl_cost), labor (lbr_cost), fixed overhead (fovhd_cost), variable overhead (vovhd_cost)
Filter for percentage variance: WHERE ABS(variance / NULLIF(current_std, 0)) > 0.05 to find items with >5% drift
Export variance report sorted by absolute dollar impact to prioritize high-value items for investigation first

Auditing BOMs and Routings for Cost Accuracy

Material cost variances usually trace to BOM issues: missing components, incorrect quantities, or outdated component costs. Query the BOM structure: SELECT b.item, b.comp_item, b.qty_per, b.scrap_pct, i.unit_cost FROM dbo.jobmatl_mst b JOIN dbo.item i ON b.comp_item = i.item WHERE b.item = 'PARENT_ITEM'. Verify quantities match engineering specifications and scrap percentages reflect actual production experience. For labor cost variances, check routing operations: SELECT r.oper_num, r.wc, r.run_lbr_rate, r.setup_hrs, r.run_hrs FROM dbo.jobroute_mst r WHERE r.item = 'YOUR_ITEM'. Confirm labor rates in work center definitions match current wage rates, and setup/run times reflect actual time study data.

Validate BOM quantities and scrap percentages against engineering specifications and recent production actuals
Check component costs are current: SELECT item, unit_cost, last_cost_update FROM dbo.item WHERE item IN (SELECT comp_item FROM dbo.jobmatl_mst WHERE item = 'PARENT')
Verify routing labor rates in work center definitions match current wage rates and burden allocations
Compare setup and run hours against actual job time reporting for the last 6 months to identify time standard drift

Executing a Clean Cost Rollup and Updating Standards

Before running the cost rollup, ensure all component-level costs are current by rolling up from the lowest BOM level upward. Use the Cost Rollup utility with the Low Level Code option to process items in the correct dependency sequence. Set the rollup parameters: cost type as Standard, include all cost elements (material, labor, fixed overhead, variable overhead), and select the appropriate BOM and routing effective dates. After the rollup completes, review the Cost Rollup Audit report for items with variances exceeding your threshold. When satisfied with the results, run the Update Item Cost utility to apply the rolled-up costs as new standard costs. This generates GL journal entries for the standard cost variance that must be posted to close the accounting period.

Process cost rollup using Low Level Code sequence to ensure component costs calculate before parent assemblies
Set effective dates for BOM and routing to capture the correct revision for the target costing period
Review Cost Rollup Audit report before applying: focus on items with >10% variance for management approval
Run Update Item Cost to apply new standards and verify GL variance journal entries post correctly to the cost variance account

Frequently Asked Questions

How often should I run cost rollups in SyteLine?

Most manufacturers run formal cost rollups quarterly aligned with financial reporting periods. However, run ad-hoc rollups whenever material costs change by more than 10%, significant BOM revisions occur, or labor rates are updated. Some organizations run monthly simulations to track cost drift without updating standards, reserving the actual standard cost update for quarterly cycles.

Why does my cost rollup show zero labor cost for manufactured items?

Zero labor cost typically means the item lacks an active routing or the routing operations have zero run/setup hours. Check the Routings form for the item and verify operations exist with non-zero hours. Also confirm the work center associated with each operation has valid labor rates defined. Items flagged as Purchased rather than Manufactured in the Item form will also skip labor calculation during rollup.

How do I handle cost rollup variances for year-end close?

At year-end, run a final cost rollup and generate the variance report before updating standards. Post the standard cost change variance to the appropriate GL account, typically a Cost of Goods Sold variance sub-account. If total variance exceeds 5% of COGS, GAAP may require allocation across inventory and COGS rather than expensing entirely. Document the variance analysis for auditor review.

Key Takeaways

1Identifying Cost Variance Sources with SQL Diagnostics: Start by comparing current standard costs against the pending rolled-up costs using the Cost Comparison report or a direct query: SELECT i.item, i.unit_cost AS current_std, cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost AS rolled_cost, ABS(i.unit_cost - (cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost)) AS variance FROM dbo.item i JOIN dbo.cost_rollup cr ON i.item = cr.item WHERE ABS(i.unit_cost - (cr.matl_cost + cr.lbr_cost + cr.fovhd_cost + cr.vovhd_cost)) > 0.01. Filter for variances exceeding your materiality threshold, typically 5% or $1.00 per unit.
2Auditing BOMs and Routings for Cost Accuracy: Material cost variances usually trace to BOM issues: missing components, incorrect quantities, or outdated component costs. Query the BOM structure: SELECT b.item, b.comp_item, b.qty_per, b.scrap_pct, i.unit_cost FROM dbo.jobmatl_mst b JOIN dbo.item i ON b.comp_item = i.item WHERE b.item = 'PARENT_ITEM'.
3Executing a Clean Cost Rollup and Updating Standards: Before running the cost rollup, ensure all component-level costs are current by rolling up from the lowest BOM level upward. Use the Cost Rollup utility with the Low Level Code option to process items in the correct dependency sequence.

Need accurate standard costs in SyteLine? Netray's cost accounting specialists can audit your cost rollup process and implement automated variance monitoring. Contact us for a cost integrity assessment.

Talk to an Expert See a Demo

Related Resources

Infor SyteLine