How to get an available amount of lot number

Question

how to get an affordable amount of lots in several warehouses

Suppose I have 3 warehouses A, B and C, Lot number LOT0001

I need the sum of the total currently available LOT0001 in all three places.

Answer 1

In odoo mode, you can pass filters in context.

Example:

context = {'lot_id': '', 'owner_id': '', 'package_id': '', 'warehouse': '', 'force_company': '', 'location': ''}

product.with_context (context) .qty_available

The odoo base module system automatically calculates a quantity based on context.

, .

.