How to test inventory valuation in Odoo

Inventory valuation testing should connect receipts, deliveries, returns, landed costs, manufacturing, valuation layers, and accounting entries.

Checking only the stock quantity misses the financial result. Checking only the journal entry misses operational errors. A useful test follows controlled products through stock movements and confirms quantity, value, cost, and accounting together. Create controlled product cases Use products with known starting quantity and cost. Cover the costing and valuation methods in scope, multiple receipts at different prices, partial delivery, return, scrap, internal transfer, and negative-stock policy. Trace the valuation layers For each movement, record the quantity, unit value, remaining value, source document, and linked accounting entry. Unexpected costs often become clear at this level before they appear in summary reports. Include manufacturing and landed costs Where applicable, test component consumption, finished goods, by-products, subcontracting, freight, duty, and allocation methods. Confirm the timing of adjustments when goods have already been sold. Reconcile at a fixed date Compare stock quantities, stock valuation, valuation layers, interim accounts, and general ledger at the same cut-off. Exclude or explain backdated and unposted documents. Practical checklist Use small cases with known expected quantity and value. Cover receipts, deliveries, returns, scrap, and transfers. Trace valuation layers to journal entries and source documents. Test manufacturing and landed-cost adjustments where relevant. Reconcile stock reports and ledger at one cut-off timestamp. Final decision Inventory valuation is trusted only when operations and accounting explain the same movement. A balanced entry alone is not enough.