get all products by each location

Question

hi every one,

how i can get all products by each location in postgreSQL?

i can´t find the table where odoo save the quantity of all products for each location

thanks in advance

Janeesh · Accepted Answer

To insert product no need to create stock moves. Stock Moves needs to created only if products quantity needs to be updated.

Ludo - 21South · Answer

That is because OpenERP does not store that information directly into Postgres. It is based on a calculated field that gets updated everytime it is triggered within OpenERP. For example, when a stock move is set to the specified location.

If you want an overview outside of Postgres, just go the specified location and print out the stock report.

If you must do this within postgres then you should loop over the stock_move table and calculate based on the product_id, destination_location_id and s

Zouhair · Answer

thank Ludo, and is the same for inserting a products? i have to insert data into much tables?

İlgili Gönderiler	Cevaplar	Görünümler
Locations Çözüldü product locations	1 Mar 15	11136
How to display inventory in each location on product view? Çözüldü product inventory locations	8 Ara 23	38598
Mass Update Product Location product inventory locations	2 Ağu 21	5112
is there anyway to relate product quantities ? stock product quantities	1 Nis 19	3332
Easily manage the default location of a product product locations odoo9	6 Eki 17	13631

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!