Skip to Content
Menu
This question has been flagged
2356 Views

i want to  appear available lots in stock but this appear available product not lots . 

exp product_qty = 10 , lot_1=0, lot_2=10 , expected from this filter  lot_2 only but lot_1 appear so .

<filter string="qty_available" name="qty" domain="[('product_id.qty_available','>', 0)]"/>


and this 

domain="[('lot_id.product_qty','>', 0)]"
gave me ValueError: Invalid field u'lot_id.product_qty' in leaf "<osv.ExtendedLeaf: (u'lot_id.product_qty', u'>', 0) on stock_production_lot (ctx: )>"
Avatar
Discard

Very interested in the solution. As time goes, you find all lots for a product, but most of the time you only want to see thoes with stock.

I think you need to filter on Quants. The quantity on hand lot is stored in quants.quantity

Related Posts Replies Views Activity
5
Sep 20
11378
1
Mar 15
4127
0
Mar 15
3014
2
Mar 15
6124
6
May 24
68936