Skip to Content
Menu
This question has been flagged
2834 Rodiniai

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: )>"
Portretas
Atmesti

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 Rodiniai Veikla
5
rugs. 20
12901
1
kov. 15
5396
0
kov. 15
4074
2
kov. 15
7634
6
geg. 24
71175