跳至內容
選單
此問題已被標幟
1 回覆
4926 瀏覽次數

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

頭像
捨棄
最佳答案

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

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
3
8月 21
3867
1
4月 24
4500
2
9月 23
4573
0
2月 22
2517
1
6月 21
5624