Why is my Odoo inventory valuation wrong?

Steps

1. Check product.category: Inventory Valuation (manual vs automated) and Costing Method (FIFO, AVCO, standard).
2. Inventory → Reporting → Valuation: compare stock.valuation.layer value to GL inventory accounts.
3. Identify stock moves posted to wrong dates or locations that skip valuation journal entries.
4. For automated valuation, open a product → Valuation tab and trace linked account.move from stock.move.
5. Run Accounting → Reconcile on inventory interim accounts (stock input/output) if anglo-saxon is enabled.
6. Fix standard price or AVCO cost on product.template only after understanding layer history.
7. Repost landed costs via stock.landed.cost if receipts were capitalized incorrectly.

Common mistakes

• Switching costing method mid-year without opening valuation adjustment.
• Manual journal entries to inventory bypassing stock.valuation.layer.
• Receiving into non-valuated locations while automated valuation is on.
• Ignoring bill status on PO receipts under perpetual valuation.
• Using inventory adjustments without setting correct unit cost on move.

Odoo version notes

Automated inventory accounting is standard in Enterprise; Community can use manual periodic journals or third-party bridges. Odoo 16–18 use stock.valuation.layer for FIFO/AVCO. Anglo-saxon COGS timing differs by company setting on res.company. After upgrades, validate account.property_stock_* accounts on categories—migrations sometimes remap chart templates.

When to bring in help

If the fix touches custom modules, regulated traceability, or production outages, a focused rescue sprint beats months of trial and error. See our Odoo service.