All Posts คน เหรียญรางวัล

แท็ก (View all)

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

How to get product quantity

stock warehouse product orm odooV8

4 ตอบกลับ

35910 มุมมอง

Md. Tanzilul Hasan Khan

I need to get product quantity on product onchange. There is a model stock_quant, which records all quantity activity.

How can I get the available quantity of the product? I am writing following function and getting stock_quantity lines but not sure how to filter out the available quantity -

    @api.multi    
    @api.onchange('product_id')    
    def product_location_change(self):
        if self.product_id:
            stock_qty_obj = self.env['stock.quant']            
            stock_qty_lines = stock_qty_obj.search([['product_id', '=', self.product_id.id]])            
            print stock_qty_lines
             # TODO: GET AVAILABLE QUANTITY OF THE PRODUCT

Md. Tanzilul Hasan Khan

ผู้เขียน คำตอบที่ดีที่สุด

For All Warehouse this is how the quantity can be checked:

product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.qty_available

For specific warehouse/location:

product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.with_context({'warehouse' : WAREHOUSE_ID}).qty_available
available_qty = product.with_context({'location' : LOCATION_ID}).qty_available

Other fields are:

Forecasted Stock => virtual_available
Incoming Stock => incoming
Outgoing Stock => outgoing

I added necessary quantity to my function.

More details are here - http://stackoverflow.com/questions/40210605/how-to-get-products-available-quantity-odoo-v8-and-v9

Usman Farzand

if i want to specific company so whats my query ?

Arian Shariat, Arian Shariat

Something odd happens using this. if you do it for two warehouses both results will be the same results as the first one. any ideas whats the problem?

Arian Shariat, Arian Shariat

I mentioned the problem here:

https://www.odoo.com/es_ES/forum/ayuda-1/odoov13-object-with-context-result-doesn-t-change-181319

Jaime Vasquez

Add a loop to the stock lines:

def product_location_change(self):
        if self.product_id:
            stock_qty_obj = self.env['stock.quant']                        
            stock_qty_lines = stock_qty_obj.search([['product_id', '=', self.product_id.id]])
            print stock_qty_lines            
            # TODO: GET AVAILABLE QUANTITY OF THE PRODUCT                
            
            available_quantity = 0            
            for row in stock_qty_lines:
 available_quantity += row.quantity #change for your quantity field
            
            print available_quantity

HTH

Md. Tanzilul Hasan Khan

ผู้เขียน

I am not asking to sum up my models line item. I know this already.

Want to find out the product quantity from stock_qty or stock_move table with locations.

Vijay Maurya

This module will help you

https://www.odoo.com/apps/modules/10.0/product_qty_in_multi_warehouse/

Md. Tanzilul Hasan Khan

ผู้เขียน

Thanks. But I have already solved.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Product Stock stock warehouse product	0 มิ.ย. 16	3848
EAV product attributes product orm odooV8	2 มี.ค. 15	6836
Odoov13 object.with_context(...) result doesn't change แก้ไขแล้ว stock warehouse product context	2 ก.ค. 22	7080
OdooV13 Get product availability in warehouses using odoo ORM แก้ไขแล้ว stock warehouse product odooV13	2 ธ.ค. 20	4441
Reading product lines - Odoo v8 - Object has no attribute '' แก้ไขแล้ว warehouse product mrp odooV8	1 ต.ค. 17	4823

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!