How to get others Company Data in v12cc ?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

1 返信

4504 ビュー

```

for product in self.env['product.product'].search([('type','=','product'),('sale_ok','=',True)]):

product_qty_available = self.env['product.product'].browse(product.id)

qty_available = product_qty_available.with_context({'to_date': last_date_of_month,'company_id':comp_id}).qty_available

```

this query return me current company data not user selection company data

where i'm wrong

what will i use sudo or else or is it possible or not ?

note comp_id is user selected company id

最善の回答

Hi Usman,

You can get the qty by the location of the Other Company's Warehouse.

1) Search the WH of the Other Company

2) Search the Stock Location(s) of the Other WH

3) Pass the location in the context: "self.with_context({'location': location_id})"

Hope this will help you.

著作者

your idea is working just one point i'm lack...pls correct me

warehouse_id = self.env['stock.warehouse'].sudo().search([('company_id','=',comp_id)],limit=1).id

its give me correct id when i select my own company other company when i select its give me false value why ?

著作者

your answer is very close to accpt pls review my last query

Make sure other WH has other company set in the Company field.

I think all of your WHs have single company selected. Please double check that and set the other company and then it will work.

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
Filter products in stock from highest quantity to 0 stock filter product qty_available odoo	1 9月 21	7291
Override create of stock.warehuse stock warehouses python3 odoo odoo12	1 12月 19	2889
name of the function that create journal entry from stock picking odoo16 stock odoo	3 7月 24	2141
How to track One2many field in Odoo12? 解決済 odoo odoo12	3 11月 23	17537
Error: Couldn't load module web 解決済 odoo odoo12	3 11月 24	25206