Inventory Valuation With Actual Costing Method Flow
Overview
The Actual Costing Method for Odoo enables precise inventory valuation by recording the real purchase or manufacturing cost of each product at the lot or serial number level. Unlike FIFO, Average, or Standard costing, this module preserves exact costs across all inventory movements, sales, refunds, and accounting entries. It provides real-time visibility into true product costs, reduces valuation discrepancies, and improves financial accuracy. Ideal for businesses managing fluctuating prices, batch-controlled inventory, and detailed cost analysis in Odoo Community Edition.
Features
- Inventory Valuation base on Costing Level of Product Category.
- Effectively reflect the Actual cost of goods based on actual purchase cost.
- Easy to track the valuation of goods based on Lot/Serial Number.
- Utilize the Actual cost of goods while generating Purchase & Sale for it.
- User can manage the Refund functionality with the Actual Costing Method.
- Generate Journal Entries for the Purchase & Sale with actual purchase cost.
- Automatic calculation of product pricing based on specified Lots or Serial Numbers.
- Support for various costing methods, such as Standard, FIFO, and Average.
- Supported in Community Edition Only.
Setup Workflow
- Navigate to Inventory >> Configuration >> Product Categories.
- Here user can create a Category or Select the Existing Category with Storeable Products.
- User need Change Costing Method to First In First Out(FIFO) and Costing Level to Lot/Serial Number.
- Navigate to Inventory >> Products >> Products.
- Here user have to set the Product Type as Storeable Product & Product Category which has the costing level set as Lot/Serial Number.
- Also user have to set the Traceability to By Lots from the Inventory Tab
- Now Navigate to Purchase and create 2 Purchase Orders with the storeable product of previously Created or Selected Product Category and different Unit Price.
- Clicking on Confirm Order button user will see a Smart Button of Receipt and state as Purchase Order.
- Click on Receipt Button and enter Lot/Serial Number for the Product.
- When user will click on Validate it will create a Inventory Valuation entry for it as WH/IN.
- To check the Inventory Valuation entry navigate to Inventory >> Reporting and then Valuation.
- Now Navigate to Sale and create 2 Sale Orders with the storeable product of previously Created or Selected Product Category.
- Clicking on Confirm Button user will see a Smart Button of Delivery and state as Sale Order.
- Click on Delivery Button and select Lot/Serial Number for the Product.
- When user will click on Validate it will create a Inventory Valuation entry for it as WH/OUT.
- Coming back to Inventory Valuation entry, Here user will see the entry for WH/OUT.
