Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
productstock_locationodooV8
1 Odgovori
5362 Prikazi
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
Opusti
Avatar
Paresh Wagh
Best Answer

Hi Thomas: 

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

Avatar
Opusti
Thomas DUPORT
Avtor

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
Avtor

I will see this model, thank you !

Related Posts Odgovori Prikazi Aktivnost
How can I see the stock location of an product? Solved
product stock_location
Avatar
Avatar
Avatar
Avatar
Avatar
18
jun. 21
29030
Module/Function that shows/returns stock locations in products Solved
stock product stock_location
Avatar
Avatar
Avatar
Avatar
16
jan. 21
17250
How can I create a listview in products form?
product listview stock_location
Avatar
1
jan. 21
8704
Read product qty on lines and on warehouses - Odoo v8
lines stock_location odooV8
Avatar
0
okt. 17
4207
I can't see updated ean13 in product_template why ?
product ean13 odooV8
Avatar
Avatar
1
maj 16
3689