OdooWiki OCA HUB

Stock Valuation Fifo Lot

stock_valuation_fifo_lot folder_open OCA/stock-logistics-workflow open_in_new
Warehouse Management License: AGPL-3

This module is used to calculate FIFO cost by lot.

auto_awesome What this module does

AI-generated from the code · Odoo 15.0

Calculates FIFO stock valuation per lot or serial number, so each lot keeps its own cost. Adds a Lots/Serial Numbers column to stock valuation layers and updates lot costs from landed costs.

This module makes Odoo value stock using the FIFO (first in, first out) method separately for each lot or serial number, instead of mixing all units of a product together.

  • On stock valuation layers, a new field lot_ids (Lots/Serial Numbers) is added and shown as tags in both the list and form views, so users can see which lot each valuation line belongs to.
  • When an incoming transfer creates a valuation layer, the lot is recorded on it. If the product uses FIFO and is tracked, the product's standard price is updated to the cost of the oldest available lot.
  • When an outgoing transfer is valued, the system picks valuation layers that contain the exact lot being shipped and consumes them in order of lot creation date, so the cost of the goods leaving matches the cost of that specific lot.
  • If a move has no purchase order but has a single lot, the price unit is taken from the existing valuation layer of that lot.
  • When a landed cost is validated, the lots produced by related manufacturing orders are written onto the generated valuation layers.

The module extends product.product, stock.move, stock.landed.cost and stock.valuation.layer. It depends on stock_account, stock_no_negative and stock_landed_costs.

Depends on

stock_accountstock_no_negativestock_landed_costs
Models and fields (4)
  • stock.move · extends an existing model
  • product.product · extends an existing model
  • stock.landed.cost · extends an existing model
  • stock.valuation.layer · extends an existing modellot_ids (Lots/Serial Numbers)

Text generated by AI (DeepSeek) from reading the Odoo 15.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 15.0

Confirmed on 2026-11-03 in branch 15.0 of OCA/stock-logistics-workflow.

terminal Installation and usage

No verified information

Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.