During an ERP implementation, the inventory valuation method is one of the least visible yet most consequential configuration decisions. It is rarely revisited after go-live, yet it directly affects your reported income, the value of your balance sheet, and the reliability of your margin analysis.
This guide is aimed at CFOs, management controllers, and finance managers at mid-market companies (50 to 2,000 employees) who want to understand the four main valuation methods — FIFO, WAVG, standard cost, and lot cost — identify which are permitted under applicable accounting standards, and learn how to configure each one in today’s leading ERP systems.
Why Inventory Valuation Is a Critical ERP Decision
Direct Impact on Reported Income and Tax
The value at which you record inventory items as expense — cost of goods sold, cost of production — depends entirely on your chosen valuation method. In a rising-price environment, the same unit quantity sold can produce very different results depending on the method: a method that flushes older lots first (FIFO) reports a lower cost of goods sold and a higher gross profit than a method that smooths prices over time (WAVG).
This is not an anomaly. It is a direct mathematical consequence of the methodological choice. Two otherwise identical companies, with the same purchases and the same sales, can report different gross margins solely because of their inventory valuation method.
Impact on Balance Sheet Value
Inventory on the balance sheet is valued using the same method. A method that flushes older lots first leaves the most recently purchased — and in an inflationary environment, most expensive — lots on the books, inflating balance sheet inventory values compared to a smoothing method. This effect is particularly pronounced in sectors with slow inventory turnover.
A Configuration Decision That Is Nearly Irreversible
In virtually all ERP systems, changing the valuation method mid-stream is technically possible but accounting-intensive: the entire on-hand stock must be revalued, revaluation journal entries must be generated, and prior-period comparatives must be restated to maintain consistency across financial statements.
This is why the decision must be made during the ERP design phase, in consultation with external auditors or the statutory accountant, and must not be left to the implementation consultant’s discretion.
The 4 Inventory Valuation Methods Explained
FIFO — First In, First Out
FIFO works on a simple principle: the first lots purchased or produced are the first to be expensed out of inventory. When a sale or consumption is recorded, the ERP draws down the oldest quantities first.
Primary advantage: the value of remaining inventory reflects the most recent purchase prices, providing a balance sheet value close to current replacement cost.
Primary drawback: in an inflationary environment, cost of goods sold is lower (older lots are cheaper), which inflates gross profit relative to the true cost of replenishing inventory.
Typical use sectors: food and beverage (mandatory traceability by expiry date), pharmaceuticals and cosmetics (use-by date management), perishables. These sectors often adopt FIFO as a regulatory requirement, independently of their accounting method.
WAVG — Weighted Average Cost
WAVG is the default method in the majority of ERP systems configured for English-speaking markets. It recalculates an average price for all inventory at each goods receipt (perpetual method) or at fixed intervals (periodic method, typically monthly).
Perpetual WAVG: at each goods receipt, the ERP immediately recalculates the new WAVG by weighting the existing stock against the new inbound lot. All subsequent issues use this updated price until the next receipt.
Periodic WAVG: the average price is calculated once per period (typically the month) using all receipts and the opening stock. All issues during that period are valued at this period WAVG, regardless of the date within the month.
The difference between these two variants may seem minor, but if your purchase prices fluctuate significantly within a month — commodity-linked raw materials, foreign currency purchases — the perpetual WAVG will produce a more accurate valuation than the periodic one.
Note for Odoo users: in Odoo 17 and 18, WAVG is labelled AVCO (Average Cost). This is the same method — perpetual weighted average cost. Many IT directors mistake AVCO for an Odoo-specific method; it is simply the standard English terminology for WAVG.
Standard Cost
Standard costing means assigning a predetermined price to each item at the start of a period or fiscal year. This price remains fixed throughout the period, regardless of actual fluctuations in purchase prices or production costs.
When an inventory receipt occurs at a price that differs from the standard cost, the ERP generates a price variance posted to a dedicated variance account in the general ledger. Analysing these variances is the core activity of industrial cost control.
Ideal use case: manufacturing companies with bills of materials (BOM), repetitive production processes, and a management accounting team capable of analysing variances monthly.
Critical SAP constraint: in SAP S/4HANA and ECC, the “Price Control” field on the material master (MM03) accepts two values — “V” for Moving Average Price (equivalent to perpetual WAVG) and “S” for Standard Price. SAP strongly discourages using “V” for materials with complex manufacturing BOMs. The technical reason: when a production order is confirmed, retroactive value adjustments on components already issued from stock can cause inconsistencies in work-in-process valuation. For manufactured items, SAP effectively mandates “S” (Standard Price). For purchased and resold items with no transformation, “V” works perfectly.
For a deeper comparison of standard costing versus actual costing in production environments, read our guide on Standard Costing vs Actual Costing in ERP: Manufacturing Cost Management.
Lot Cost — Specific Identification
Lot costing assigns a specific cost to each batch of goods, identified by its lot or serial number. When that lot is drawn from inventory, its specific cost is expensed — with no smoothing or weighting against other lots.
Use cases: sectors with high cost variance between lots — specialty chemicals (raw materials priced individually per contract), luxury goods and jewellery (diamonds and precious materials with highly variable per-unit costs), pharmaceuticals (active pharmaceutical ingredients with different synthesis costs per production campaign).
Operational constraint: this method requires rigorous lot traceability in the ERP from goods receipt through to issue. Without a lot number systematically recorded at receipt, the method is unworkable in practice.
What Accounting Standards Require
IFRS — IAS 2
International Financial Reporting Standard IAS 2 (Inventories) permits only two methods for measuring the cost of inventories:
- FIFO (first in, first out)
- WAVG (weighted average cost, perpetual or periodic)
LIFO is explicitly prohibited under IFRS, regardless of where the reporting entity is incorporated. This is a point that controllers joining a subsidiary from a US corporate background frequently overlook.
US GAAP — ASC 330
Under US GAAP, LIFO (Last In, First Out) remains permitted. A US parent company may therefore apply LIFO for its consolidated US financial statements, while its European or UK subsidiaries are required to use FIFO or WAVG for their statutory accounts. This cross-framework reconciliation point must be anticipated in the configuration of any multi-entity ERP.
UK GAAP / FRS 102
Under FRS 102, the framework used by most UK companies, LIFO is not permitted for inventory measurement. FIFO and WAVG are the accepted methods, consistent with IFRS IAS 2.
ERP Configuration: System-by-System Guide
SAP S/4HANA and ECC
Valuation method configuration is done on the material master (transaction MM03), Accounting 1 tab:
- Field “Price Control”: S = Standard Price, V = Moving Average Price
- Standard cost (S) is managed via cost estimate transactions (CK11N / CK40N to run cost estimates, then CK24 to mark standard prices)
- Price variances are analysed in report MM60 (price movement analysis)
- Transaction MR21 allows manual update of a standard price outside the cost estimate cycle
For purchased items: V (WAVG) is appropriate. For items manufactured with a BOM: S (Standard Price) is required.
Odoo 17 and 18
Configuration in Odoo is a two-step process:
- Enable in inventory settings: Configuration > Settings > Inventory > enable “Costing Methods”
- Set per product or product category (General Information tab > “Costing Method” field): three options are available — Standard Price, Average Cost AVCO (perpetual WAVG), and First In First Out (FIFO)
Switching from Standard Price to AVCO or FIFO on a product already in stock automatically triggers a revaluation of on-hand inventory at the time of the change. Odoo records the variance in a configurable inventory valuation adjustment account.
Sage X3
In Sage X3, the valuation method is configured at the product category level (parameter “Valuation Mode”) — not article by article:
- FIFO: first in, first out
- WA: weighted average (equivalent to WAVG)
- Standard: standard cost
The parameter applies to all items within the category. If you have items of different natures requiring different methods, separate product categories must be created.
Microsoft Dynamics 365 Business Central
Business Central offers five costing methods, configurable per item via the “Costing Method” field on the item card:
- FIFO: first in, first out
- LIFO: last in, first out (available in the UI but non-compliant with IFRS and most national GAAPs outside the US — do not use for UK or European entities)
- Average: weighted average cost (WAVG)
- Standard: standard cost
- Specific: specific lot or serial number cost (equivalent to lot costing)
LIFO appears in the interface but using it for entities subject to IFRS or local GAAP prohibiting LIFO would constitute a compliance breach.
| ERP | WAVG | FIFO | Standard | Lot Cost | Configuration Path |
|---|---|---|---|---|---|
| SAP S/4HANA | V (MAP) | Not native | S (Standard) | Batch valuation | MM03 > Accounting 1 |
| Odoo 17/18 | AVCO | FIFO | Standard Price | Not native | Inventory Settings > Product Category |
| Sage X3 | WA | FIFO | Standard | Not native | Product Category > Valuation Mode |
| D365 Business Central | Average | FIFO | Standard | Specific | Item Card > Costing Method |
Worked Example: FIFO vs WAVG — Quantified Impact
To illustrate the income effect, here is a representative example for an industrial distributor.
Scenario:
- 1st receipt: 100 units at £10.00 each (Lot A)
- 2nd receipt: 100 units at £12.00 each (Lot B)
- Total stock after receipts: 200 units valued at £2,200
- Sales for the period: 150 units at £15.00 each (revenue = £2,250)
FIFO valuation:
- The 100 units from Lot A are issued first (100 × £10 = £1,000)
- Then 50 units from Lot B (50 × £12 = £600)
- Cost of goods sold = £1,600
- Gross profit = £2,250 − £1,600 = £650 (28.9%)
- Closing stock: 50 units at £12 = £600
WAVG valuation:
- After both receipts, WAVG = (100 × £10 + 100 × £12) / 200 = £11.00 per unit
- Cost of 150 units sold = 150 × £11 = £1,650
- Gross profit = £2,250 − £1,650 = £600 (26.7%)
- Closing stock: 50 units × £11 = £550
Reading the results: on this single example, FIFO reports £50 more gross profit and £50 more closing stock value than WAVG. In a rising-price environment, FIFO consistently produces a higher gross profit and a higher balance sheet inventory value. In a deflationary environment, the effect reverses.
At year-end close, this effect compounds across every active SKU. For a mid-market distributor with 5,000 active references and purchase prices rising 5% over the year, the difference in reported profit between the two methods can run to hundreds of thousands of pounds. CFOs must be aware of this at the initial configuration decision — well before the first year-end close.
The Link Between Inventory Valuation and Accounting Close
The valuation method interacts directly with period-end operations. Two areas warrant particular attention.
Goods received not invoiced (GRNI): when a physical receipt is recorded in the ERP before the supplier invoice arrives, the system generates a provisional receipt entry. Under WAVG, this provisional price immediately enters the new WAVG calculation. When the actual invoice arrives at a different price, the ERP generates a variance that must be cleared. At monthly or year-end close, GRNI balances represent a source of valuation variances to manage carefully. Our guide on ERP Year-End Close: The CFO Checklist covers this process in detail.
Physical inventory adjustments: during the mandatory annual physical stock-count, if count variances are found between ERP quantities and physical quantities, the adjustment entry is valued using the method in force. Adjusting down 100 units valued at £11.00 (WAVG) versus £12.00 (FIFO) does not generate the same accounting loss. This point is frequently underestimated in companies with high SKU counts.
The valuation method is also the starting point of the procure-to-pay (P2P) process: it is at goods receipt in the ERP that inventory value is first established. To understand how to optimise this end-to-end flow, see our guide on ERP Procurement: Complete Guide to Procure-to-Pay Optimization.
Checklist: Choosing Your Valuation Method
Before finalising your decision, answer these five questions with your CFO and ERP implementation consultant:
1. Do you have manufacturing operations with bills of materials? If yes, standard costing is generally the only method compatible with robust product profitability analysis. WAVG in a manufacturing environment smooths variances and masks performance drift.
2. Do your purchase prices vary significantly from one order to the next? If yes, FIFO preserves per-lot cost traceability. WAVG smooths these variations — an advantage or a drawback depending on your analytical needs.
3. Do you have lot traceability obligations (expiry dates, regulatory lot numbers)? If yes, FIFO or lot costing is often an operational constraint before it is an accounting choice.
4. Do you have entities subject to IFRS or to a local GAAP that prohibits LIFO? If yes, exclude LIFO from your configuration immediately, even if your ERP makes it available.
5. Do you have a management accounting team capable of analysing variances monthly? If not, standard costing will generate unanalysed variances that pollute your accounts. Start with WAVG and consider migrating to standard cost as your team matures.
| Business type | Recommended method |
|---|---|
| Pure distribution (buy-sell, no transformation) | WAVG |
| Repetitive discrete manufacturing | Standard cost |
| Food, pharma (expiry date traceability) | FIFO |
| Make-to-order / engineer-to-order | Standard cost or lot cost |
| Distribution with highly volatile purchase prices | FIFO or perpetual WAVG |
| Specialty chemicals, luxury goods (high cost variance per lot) | Lot cost |
A mid-year method change is possible but triggers a full revaluation of on-hand inventory and affects the comparability of IFRS financial statements (IAS 8, paragraph 14, on changes in accounting policies). Switching from WAVG to FIFO mid-fiscal year without notifying your external auditors is a common mistake — and an expensive one to correct.
Download our ERP evaluation scorecard — 100 criteria to benchmark 3 vendors: 30 criteria covering accounting and inventory management modules, side by side on a single scoring grid. Ideal for structuring an RFP or validating a shortlist before product demos.
