Skip to Content
Menú
This question has been flagged
1 Respondre
4902 Vistes

I created a custom field in sale.order.line


_inherit = "sale.order.line"


maximum_quantity = fields.Float (string = 'Maximum Quantity', default = check_max_quan)


# then i called this method to fetch product available quantity and pass it to maximum quantity by default

def check_max_quan (self):

max_quan = self.env ['product.template']. search ([['product_id', '=', self.product_id]]). qty_available
return max_quan



# But this logic is not working i am unable to pass qty_available value of product to my custom created field

Avatar
Descartar
Best Answer

Hi Mayank,


try the below solution to get Available Qty of Product from the Main Stock

>> product_id = self.env ['product.template']. search ([['product_id', '=', self.product_id]]) 

>> max_quan = product_id.with_context(
location=line.order_id.warehouse_id.lot_stock_id.id,
warehouse_id=line.order_id.warehouse_id.id
).qty_available


Thanks & Regards,

Sunny Sheth

Avatar
Descartar
Related Posts Respostes Vistes Activitat
3
d’ag. 21
3857
1
d’abr. 24
4481
2
de set. 23
4562
0
de febr. 22
2505
1
de juny 21
5610