| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 579 |
| Technical Name |
kaz_stock_account_actual |
| License | OPL-1 |
| Website | http://www.kaizenae.com/ |
| Versions | 16.0 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 579 |
| Technical Name |
kaz_stock_account_actual |
| License | OPL-1 |
| Website | http://www.kaizenae.com/ |
| Versions | 16.0 17.0 18.0 |
Lot-Level Costing (FIFO/AVCO)
for Odoo
Lot-Level Costing (FIFO/AVCO) by Kaizen Principles gives finance and operations teams audit-ready accuracy without changing how they work. Administrators enable âCosting Level: Lots/Serial Numbersâ on products or categories, and the module takes care of the rest: outgoing moves are valued by the exact lot consumed, Stock Valuation Layers record the lot and unit cost, and a per-lot revaluation wizard updates value and posts entries when real-time valuation is enabled. Optional header actions on the Lot form provide one-click access to valuation layers and revaluation, while enhanced views add search/group-by for lots. The result is precise COGS, cleaner reconciliations, and full traceability by batch/serial delivered within Odooâs standard screens and flows, with no new menus or complex processes.
© 2025 Kaizen Principles
What's New in Lot-Level Costing (FIFO/AVCO) for Odoo
Enables real-time cost tracking for better visibility and control
Provides item-level costing based on each Lot or Serial Number
Seamlessly integrates with other Odoo applications and workflows
Allows tracking of actual costs during product procurement
Delivers accurate cost reports by using true cost values
Kaizen Principles
Your Partner
We're here to support your growth 24/7. Connect with our experts now.
All Features
Lot-Aware Stock Valuation Layer (SVL): Integrates lot/serial numbers directly into the Stock Valuation Layer, allowing for detailed cost tracking per lot. Each SVL entry will now be associated with a specific lot, providing granular visibility into inventory costs.
Accurate Delivery Valuation: When products are delivered, their Cost of Goods Sold (COGS) is calculated based on the exact cost of the specific lot or serial number being shipped, ensuring greater accuracy in financial reporting
Lot-Level Revaluation Wizard: Introduces a dedicated wizard for revaluing inventory at the lot/serial number level. This feature allows users to adjust the cost of specific lots, with automatic generation of corresponding accounting entries if real-time valuation is enabled
Quant Valuation from Lot Data: Inventory quantities (quants) are valued based on the remaining quantities and values associated with each individual lot, providing a more precise valuation of on-hand stock.
Enhanced User Interface: Updates to the Odoo user interface include the display of lot information on stock moves and the ability to search and group inventory data by lot/serial number, improving usability and traceability.
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Free 30 Days Support
Kazien Principles will provide FREE 30 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.
Lot-Level Costing (FIFO/AVCO)
Gain full transparency into inventory valuation every batch and serial is costed, tracked, and auditable in real time directly inside Odoo. With Lot-Level Costing (FIFO/AVCO) by Kaizen Principles, outgoing moves are valued by the exact lot consumed, Stock Valuation Layers capture lot and unit cost, and a guided revaluation wizard adjusts value per lot with automated journal entries when real-time valuation is enabled. From remaining quantities and per-lot unit costs to filtered valuation histories and one-click actions on the Lot form, everything is generated and available instantly, eliminating manual reconciliations. Each movement and revaluation is recorded for complete audit trails and regulatory compliance. Whether youâre closing the month, investigating cost variances, or serving regulated industries, this module centralizes lot-level costing, boosts accuracy, and elevates finance and warehouse collaboration without introducing new menus or complex workflows.
-
Open Product Categories
-
Set Costing Method & Level
-
Create a Storable Product & Assign Category
-
Enable Lot Tracking
-
Create Purchase Order for Lot Receipt
-
Confirm RFQ to Purchase Order
-
Open the Receipt
-
Open Detailed Operations & Assign Lot
-
Assign Lot/Serial & Confirm
-
Create Second Purchase at New Cost
-
Assign Second Lot & Complete Receipt
-
Create Sales Order
-
Validate Delivery with Selected Lot
-
Create Second Sales Order
-
Validate Second Delivery (Next Lot)
-
Review Stock Valuation by Lot
-
Run âValuation at Dateâ
-
Review Valuation Snapshot (As-of Date)
Open Product Categories
Set Costing Method & Level
Create a Storable Product & Assign Category
Enable Lot Tracking
Create Purchase Order for Lot Receipt
Confirm RFQ to Purchase Order
Open the Receipt
Open Detailed Operations & Assign Lot
Assign Lot/Serial & Confirm
Create Second Purchase at New Cost
Assign Second Lot & Complete Receipt
Create Sales Order
Validate Delivery with Selected Lot
Create Second Sales Order
Validate Second Delivery (Next Lot)
Review Stock Valuation by Lot
Run âValuation at Dateâ
Review Valuation Snapshot (As-of Date)
Open Product Categories
In the Inventory app, go to Configuration - Product Categories. Youâll edit the category to enable Costing Level - Lots/Serial Numbers (FIFO) for lot-level valuation.
Set Costing Method & Level
On the Product Category form, under Inventory Valuation, set: Costing Method = First In First Out (FIFO) Costing Level = Lots/Serial Numbers This enables lot-level valuation for all products in this category (company-dependent) and keeps COGS/audit trails aligned with the exact lots you move.
Create a Storable Product & Assign Category
In Inventory - Products - Create, add your item (e.g., Test Product). Set Product Type = Storable Product and choose the Product Category you configured (FIFO + Lots/Serial Numbers). Keep Can be Sold/Can be Purchased enabled as needed.
Enable Lot Tracking
On the product Inventory tab, under Traceability, set Tracking = By Lots (use By Unique Serial Number if you track individually). Tracking is required for lot-level FIFO/AVCO valuation without it, the costing level wonât apply.
Create Purchase Order for Lot Receipt
In Purchase - Orders - Create, add your tracked product (e.g., Test Product), set the Quantity (e.g., 10) and Unit Price (e.g., 100). Confirm the RFQ to a Purchase Order youâll receive this lot next to establish the lotâs incoming cost for FIFO/AVCO.
Confirm RFQ to Purchase Order
On the RFQ, click Purchase Order to confirm. This fixes the price/qty and generates the incoming receipt for your tracked product (e.g., 10 Ã 100). Youâll receive it next and assign the lot to establish the lotâs incoming cost for FIFO/AVCO.
Open the Receipt
On the confirmed Purchase Order, click the â1 Receiptâ smart button to open the incoming picking. Youâll record the received quantity and assign the Lot/Serial for this purchase so FIFO/AVCO uses the correct incoming cost.
Open Detailed Operations & Assign Lot
In the incoming receipt, click the list icon in the Done column to open Detailed Operations. Enter the received Done Qty and assign/create the Lot/Serial for this product. This records the lot that will carry the incoming cost for FIFO/AVCO.
Assign Lot/Serial & Confirm
In Detailed Operations, enter the Lot/Serial Number (e.g., 0001) and make sure Quantity Done matches what you received (e.g., 10.00). Click Confirm to apply the lot to this receipt line.
Create Second Purchase at New Cost
Create and confirm another Purchase Order for the same tracked product (e.g., 10 @ 200.00). Click the â1 Receiptâ smart button to receive it and assign a new Lot/Serial (e.g., 0002). This sets up a second lot with a different cost so FIFO/AVCO can demonstrate lot-level valuation across multiple incoming prices.
Assign Second Lot & Complete Receipt
In Detailed Operations, set the Lot/Serial Number to the new lot (e.g., 0002) and verify Quantity Done (e.g., 10.00). Confirm/close the dialog to record this receipt. You now have two lots with different costs, ready to demonstrate lot-level FIFO/AVCO.
Create Sales Order
In Sales - Quotations - Create, add the tracked product (e.g., Test Product) with the desired Quantity (e.g., 5) and Unit Price (e.g., 150). Confirm to Sales Order. This will generate 1 Delivery, where youâll choose which lot to ship demonstrating lot-level FIFO/AVCO on outbound moves.
Validate Delivery with Selected Lot
On the outbound delivery, confirm the Lot/Serial Number (e.g., 0001) for the product, then click Validate. This completes the shipment and posts lot-aware valuation (SVL) so COGS reflects the exact lot under FIFO/AVCO.
Create Second Sales Order
In Sales - Quotations - Create, add Test Product again with the new Quantity (e.g., 5) and Unit Price (e.g., 250), then confirm to Sales Order. This generates 1 Delivery, which will be fulfilled from the next available lot (FIFO) so you can demonstrate lot-level costing using a different incoming cost.
Validate Second Delivery (Next Lot)
On the delivery created from the second Sales Order, confirm the reserved Lot/Serial Number (e.g., 0002) and click Validate. This completes the shipment and posts valuation using the second lotâs cost, demonstrating lot-level FIFO/AVCO across different incoming prices.
Review Stock Valuation by Lot
In Inventory - Reporting - Valuation, expand the product to see each Stock Valuation Layer. Verify that receipts show positive qty with their Lot/Serial and unit value (e.g., 0001 at 100, 0002 at 200), and deliveries show negative qty using the same lot costs confirming lot-level FIFO/AVCO. The subtotal equals your current on-hand value.
Run âValuation at Dateâ
Go to Inventory - Reporting - Valuation and click Valuation at Date. Choose the cutoff date/time to generate a snapshot of on-hand quantity and inventory value. Use it to verify per-lot unit costs and totals as of a specific date for audits or month-end close.
Review Valuation Snapshot (As-of Date)
After running Valuation at Date, verify the timestamp at the top matches your cutoff, then expand the product to review each SVL line by Lot/Serial, Moved Quantity, and Unit Value. Confirm the subtotal equals your on-hand value as of that exact moment useful for audits and month-end close.
Why Kaizen
You know us as the makers of the Odoo "Lot-Level Costing (FIFO/AVCO) for Odoo".
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Kaizen Odoo Services
Upscale your business with expert services from an Odoo Gold Partner.
Module Development
Implementation
Customization
Integration
Migration
Support & Maintenance
Consulting
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module