Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Все посты Люди Значки
Теги (Смотреть все)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
stockwarehouseproductormodooV8
4 Ответы
34056 Представления
Аватар
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

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?

Аватар
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.

Похожие посты Ответы Просмотры Активность
Product Stock
stock warehouse product
Аватар
0
июн. 16
3170
EAV product attributes
product orm odooV8
Аватар
2
мар. 15
5738
Odoov13 object.with_context(...) result doesn't change Решено
stock warehouse product context
Аватар
Аватар
Аватар
2
июл. 22
5770
OdooV13 Get product availability in warehouses using odoo ORM Решено
stock warehouse product odooV13
Аватар
Аватар
2
дек. 20
3532
Reading product lines - Odoo v8 - Object has no attribute '' Решено
warehouse product mrp odooV8
Аватар
Аватар
1
окт. 17
4081