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

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
Opusti
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
3
avg. 21
3311
1
apr. 24
3766
2
sep. 23
3970
0
feb. 22
2059
1
jun. 21
4901