İçereği Atla
Bu soru işaretlendi
productstock_locationodooV8
1 Cevapla
5329 Görünümler
Avatar
Thomas DUPORT

Hello, i'm on Odoo 8

I want to get my products and the locations of these products in a SQL query, to put it in a jrxml file (for Jasper report).

What is the link between stock.location and product.product (or product template) ?
I didn't found location_id in product_product or product template. 

I saw this in addons/stock/product.py :

'location_id': fields.dummy(string='Location', relation='stock.location', type='many2one'),

I don't know if i can use this.

Avatar
Vazgeç
Avatar
Paresh Wagh
En İyi Yanıt

Hi Thomas: 

This information is stored in stock.quant in Odoo 12. Check whether this same model exists in Odoo 8.

Avatar
Vazgeç
Thomas DUPORT
Üretici

Hello, thank you for your answer !

I saw stock quant many times in code but i never understand what it is concretely, can you explain me please?

Paresh Wagh

This is the model used to display the Inventory Report (Inventory > Reporting > Inventory Report). Odoo keeps a track of the reserved qty and the qty on hand by product, company, location in this model.

Thomas DUPORT
Üretici

I will see this model, thank you !

İlgili Gönderiler Cevaplar Görünümler Aktivite
How can I see the stock location of an product? Çözüldü
product stock_location
Avatar
Avatar
Avatar
Avatar
Avatar
18
Haz 21
28960
Module/Function that shows/returns stock locations in products Çözüldü
stock product stock_location
Avatar
Avatar
Avatar
Avatar
16
Oca 21
17219
How can I create a listview in products form?
product listview stock_location
Avatar
1
Oca 21
8672
Read product qty on lines and on warehouses - Odoo v8
lines stock_location odooV8
Avatar
0
Eki 17
4162
I can't see updated ean13 in product_template why ?
product ean13 odooV8
Avatar
Avatar
1
May 16
3665