Infor SyteLine3 min readNetray Engineering TeamUpdated March 4, 2025

How to Set Up Actual Costing in SyteLine

Actual costing in SyteLine captures real material, labor, and overhead costs as transactions occur, giving manufacturers a true picture of production expenses. Unlike standard costing, actual costing eliminates purchase price variances by posting real costs directly to inventory. This guide covers the complete configuration of actual costing methods including weighted average and FIFO in CloudSuite Industrial.

Selecting the Actual Cost Method

Navigate to Finance > Costing > Costing Parameters to set the site-level cost method. SyteLine supports weighted average and FIFO as actual costing methods. The costing_parms table stores the site configuration, and the SL_CostingParms IDO manages updates. Weighted average recalculates unit cost with each receipt, while FIFO maintains cost layers that are consumed in receipt order during issues.

Open Costing Parameters and set the Cost Method field to 'Average' or 'FIFO' for the active site
Configure the Material Cost Basis to 'Actual' to track real purchase prices on receipts
Enable labor cost tracking by setting Labor Cost Basis to 'Actual' for work order operations
Set the Overhead Application method to either actual hours or actual costs depending on your absorption strategy

Configuring Cost Layers and Inventory Valuation

For FIFO costing, SyteLine creates cost layers in the inv_cost_layer table each time inventory is received at a new cost. The SL_InvCostLayer IDO manages layer creation and consumption. Navigate to Products > Inventory > Inventory Cost Layers to view existing layers per item and warehouse. Weighted average costs are maintained directly on the item_cost record and recalculated automatically with each receipt transaction.

Review cost layer creation settings in Costing Parameters to control layer granularity
Monitor the Inventory Cost Layers form for layer accuracy and potential negative layer issues
Configure the Maximum Cost Layers parameter to prevent excessive layer proliferation on high-volume items
Set up the Cost Layer Cleanup utility to archive consumed layers older than your retention period

Handling Work Order Cost Collection

Actual costing on work orders collects real material issue costs and actual labor hours multiplied by employee or work center rates. Navigate to Production > Shop Floor > Work Order Transactions to monitor cost accumulation. The SL_WoMatlTrans and SL_WoLbrTrans IDOs capture material and labor postings respectively. Overhead is applied based on actual activity using rates configured on the Work Center form.

Ensure work center actual labor rates are maintained on Production > Resources > Work Centers
Configure overhead application rates as percentage of labor or per-hour fixed amounts
Review work order cost accumulation on the Work Order Costs tab before closing orders
Run the Work Order Close process to finalize actual costs and post variances to the general ledger

Frequently Asked Questions

What is the difference between weighted average and FIFO costing in SyteLine?

Weighted average recalculates a single unit cost after each receipt by blending the new receipt cost with existing inventory value. FIFO maintains separate cost layers consumed in receipt order. Weighted average is simpler with 1 cost per item, while FIFO can generate 50-200+ layers per item annually. FIFO provides more accurate COGS but requires more storage and processing.

Can I switch from standard to actual costing in SyteLine?

Yes, but switching cost methods requires careful planning. SyteLine supports cost method changes at period boundaries. You must run inventory revaluation to adjust all on-hand quantities to actual costs, which generates GL entries. Most transitions take 2-3 months of parallel processing. Back up the database before conversion and validate with 30-60 test items first.

How does actual costing affect SyteLine financial reporting?

Actual costing eliminates purchase price variance accounts since real costs post directly to inventory. However, you may see work order efficiency variances if actual labor differs from estimated hours. Financial reports reflect true costs per unit, improving gross margin accuracy. Expect 15-25% more GL transaction volume compared to standard costing due to layer-level postings.

Key Takeaways

1Selecting the Actual Cost Method: Navigate to Finance > Costing > Costing Parameters to set the site-level cost method. SyteLine supports weighted average and FIFO as actual costing methods.
2Configuring Cost Layers and Inventory Valuation: For FIFO costing, SyteLine creates cost layers in the inv_cost_layer table each time inventory is received at a new cost. The SL_InvCostLayer IDO manages layer creation and consumption.
3Handling Work Order Cost Collection: Actual costing on work orders collects real material issue costs and actual labor hours multiplied by employee or work center rates. Navigate to Production > Shop Floor > Work Order Transactions to monitor cost accumulation.

Implementing actual costing in SyteLine? Netray's manufacturing ERP experts can help you choose between weighted average and FIFO methods and configure cost tracking to match your operational needs.

Talk to an Expert See a Demo

Related Resources

Infor SyteLine