Stock Lot Filter Available

This module makes it easier to find the lots and serial numbers that still have stock on hand. It adds a new filter called "On hand" to the search bar of the lot/serial number list (the stock.production.lot screen). When you switch it on, Odoo only shows lots whose available quantity is greater than zero.

The available quantity is worked out from the stock quantities recorded in internal and transit locations, so only real on-hand stock is counted. Lots that have no stock left are hidden when the filter is active.

Because the quantity used by the filter is a searchable value, the same logic can be used in other searches on lots, for example to look for lots with a quantity equal to zero, greater than a value, or below a value. Unsupported search comparisons are rejected.

• Where it appears: the search bar of the lot/serial number screen, next to the product filter.
• What it adds: an "On hand" filter that keeps only lots with available stock.
• Business rule: availability is based on quantities in internal and transit locations.
• Areas touched: lot/serial numbers (stock.production.lot) and stock quantities (stock.quant).