OdooWiki OCA HUB

Stock lot product qty search

stock_lot_product_qty_search folder_open OCA/stock-logistics-workflow open_in_new
Inventory/Inventory License: AGPL-3

This module adds a search function on the Quantity (product_qty) field of Lot/Serial Numbers (stock.production.lot) model, in order to search on this field and provide a filter for records having a quantity on hand.

auto_awesome What this module does

AI-generated from the code · Odoo 15.0

Lets users search and filter Lot/Serial Numbers by their quantity on hand in Odoo Inventory.

This module makes the Quantity field of Lot/Serial Numbers searchable, so users can find lots based on how much stock is actually available.

In the Lot/Serial Numbers screen, the search panel gains an "On hand" filter that shows only lots with a positive quantity. Users can also type quantity conditions (for example greater than, less than, equal to) in the search box.

The quantity is calculated from stock quants located in internal locations and in transit locations that belong to a company. Lots with no stock are treated as zero when the search condition includes zero, so they can still be found.

Only standard comparison operators are accepted; anything else raises an error, and the value searched must be a number. The module extends the stock.production.lot model and adds a search filter to the existing lot search view.

Depends on

stock
Models and fields (1)
  • stock.production.lot · extends an existing modelproduct_qty

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: 2 confirmed, 7 with no information of 9 versions.

Sources · Odoo 14.0

Confirmed on 2026-11-03 in branch 14.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.