Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
4491 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
3
Agu 21
3577
1
Apr 24
4165
2
Sep 23
4267
0
Feb 22
2267
1
Jun 21
5310