Odoo Help


Quantity On Hand is always zero Stock Quants issue

Fabio Canella
on 3/9/16, 6:29 AM 3,595 views

Hello I'm configuring Odoo 8 but I have some trouble with Quantity On Hand.

When I make a warehouse movement or Inventory movement I see under Move Window the transaction correctly with the correct quantity, but the Moved Quants is always with quantity zero, so the on hand quantity of the product is always zero.

No errors is shown in the log... I can't understand te problem.

Best regards

Are you saying your are making internal trasnfers

on 3/10/16, 3:03 AM

Or you are just updating inventory in your warehouse. Plz share screen shots if any

on 3/10/16, 3:04 AM

Is your warehouse correctly configured ? For example if location isn't correctly "related" to the warehouse it will not work.

Parent / Child
Stock / your location
Dr Obx
on 3/10/16, 5:07 AM

How can share a screen ?

Fabio Canella
on 3/11/16, 8:42 AM

You can take static screen shots of the steps you have performed by using extensions present on ur browser( Extension like Lightshot or awesome screen shots). If you don't have these extensions plz add them on your browser and you can share screen shots

on 3/11/16, 8:50 AM

I can't edit my post or post a new answer with some images (error 403 forbidden)

Fabio Canella
on 3/11/16, 9:46 AM
Fabio Canella
On 4/2/16, 12:15 PM

Finally I found the problem ! 

I don't know why but the rounding field of the uom Units have to be set to 0,001 !? In my database was 0 (I never changed it !).

I don't understand why this field have to be set to 0,001... I suspect that is a "workaround" due a not well made programming style.

Thank you for your support 

Resham Kumari
On 2/1/18, 3:08 PM

Hi, Might be I am replying too late, Recently i had same Issue. I am updating quantity for product and i can see that quantity in stock but not able to use and see that in Product view. I found the reason behind it.  Some how stock module was not installed properly and because of that locations are not created properly. Normally when we install stock module it creates default locations with parent left and parent right value and in buggy database it was missing somehow. So I just updated parent left and parent right to buggy database and my problem resolved.  

Andi Akbarry Renaldy
On 10/31/17, 10:13 AM

Hi Fabio

I've changed the rounding of the uom unit to 0.001 but it has not worked yet

On 3/11/16, 9:55 AM


Ok. As per me what i understand from your issue is that, might the Stock module has not been installed properly as there might happened some server issues during installation process or any other technical fault during module installation. My recommendation would be that, kindly uninstall your previously installed module and perform afresh installation of the stock module.

Reasons behind recommending you to reinstall the Stock module is because there have been instances which we have faced in real time that quantities are not updated when module installation was not proper 

Hi Nilim I've tried to uninstall stock and then reinstall the stock module in a test environment with che real database but the problem still exists. I also tried to install a clean database in the same server, with the same warehouse configuration and all is ok, the quantity is managed correctly in the clean database. But I have to solve the problem in the database with the real data... so I'm thinking to debug the code... can you suggest me please what is the class/method where is chosen how manage the quants quantity ? Best regards

Fabio Canella
on 3/16/16, 10:57 AM

I see that in the table stock_move, the product_uom_qty is correct but the product_qty is always zero... this could be the origin of the problem ?

Fabio Canella
on 3/18/16, 10:39 AM

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

3 follower(s)


Asked: 3/9/16, 6:29 AM
Seen: 3595 times
Last updated: 2/1/18, 3:08 PM