Skip to Content
Menu
This question has been flagged
1 Reply
2279 Views

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
Discard
Best Answer

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

Avatar
Discard
Author

not working,same as before

Related Posts Replies Views Activity
2
Aug 20
2762
0
Dec 19
3194
0
Dec 20
2631
0
Oct 20
2984
0
May 20
2606