Odoo Help


This community 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.

OpenERP Master
On 6/18/14, 7:17 PM

There is a postgres view called stock_report_prodlots, that has this information calculated by location. This is a decent method for getting stock values. I have used it for valuation reports. Calling the python methods for each product can be slow.

The stock as the other user mentioned is stored in the table stock_move. Each time a move occurs a new entry is created. It is a double entry system. A product is moved from one location and put in another.


Ludo - Neobis

--Ludo - Neobis--
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--


Ludo - Neobis
On 6/18/14, 6:40 AM

It is not recorded. The quantity of a product is calculated each time a new stock move has been generated. You will not find an absolute quantity in the database.

For the description behind this, please look at the documentation on Stock and Warehousing:


Your Answer

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)


Asked: 6/18/14, 3:23 AM
Seen: 676 times
Last updated: 3/16/15, 8:10 AM