Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2829 Prikazi

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
Opusti

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 Odgovori Prikazi Aktivnost
5
sep. 20
12901
1
mar. 15
5389
0
mar. 15
4072
2
mar. 15
7633
6
maj 24
71173