Skip to Content
Menu
This question has been flagged
1 Odpoveď
2365 Zobrazenia

I am trying to deliver a Stock Move ,and in the lot/serial number field I should Only see serial numbers(lot_id) of product variants with Qty on hand.

look at this item(pic included). and all the lot ids. this item has a on hand of 5. we should only see the 5 lot ids.Tied to this.i did try this(my code is given below),  and also other methods too, but in this case it shows all records first after changing once i gets the required values, is there any other way to get my required values on the first click ??i need The results shown in Second Pic Is In My First Click, Is there any solution For This?


code:

@api.onchange('lot_id')
def _show_appropriate_serial_number(self):
print("hello i can show up here")
quantity_on_hand = self.env['stock.quant'].search([('on_hand', '=', True)])
lists = []
for rec in quantity_on_hand:
if self.product_id == rec.product_id:
lists.append(rec.lot_id.id)
print(lists)
return {'domain': {'lot_id': [('id', 'in', lists)]}}


Avatar
Zrušiť
Best Answer

change 'in' to '=' and check again last line of your code, hope this will work :)

Avatar
Zrušiť
Autor

not working,same as before

Related Posts Replies Zobrazenia Aktivita
2
aug 20
2859
0
dec 19
3296
0
dec 20
2752
0
okt 20
3102
0
máj 20
2749