Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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
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 source_location_id (or something like that).
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/28/14, 9:24 AM|
|Seen: 1048 times|
|Last updated: 3/16/15, 8:10 AM|