Odoo Help


Qty Available Not Calculating Properly

Jeffrey Russell
on 5/20/16, 6:25 PM 404 views

Having a problem with quantity on hand (available) not showing on product screen.   Also, entering a line on sales order always results in a warning of '0' available.

When updating QOH either through the 'Update Qty On Hand' button on the product screen or through an inventory adjustment everything looks fine in inventory.

The 'On Hand' always shows '0' on the product view even after making the adjustment.  When clicking 'On Hand' it brings up the inventory location(s) and shows the quantities there just fine.

When trying to add the product on a sales order line the no stock warning appears.

This happens with an existing product item or newly created product always the same result.

This seems to be virtual_available is not calculated correctly.   Obviously something is not configured correctly.   Everything works fine on a test 'demo' Odoo 9 database.

Do you have more than 1 warehouse? Maybe you adjusted the inventory in Warehouse A and are trying to sell from Warehouse B. If you can reproduce the issue at runbot.odoo.com, report at help@odoo.com, but it definitely sounds like a configuration problem.

Fabrice Henrion (fhe)
on 5/20/16, 9:38 PM
Jeffrey Russell
On 5/22/16, 3:58 PM

The answer:

Our warehouse & locations were imported from an existing OpenERP v7 system.  Something in the way the warehouse was set up must be incompatible or configured wrong.   When creating a new warehouse & locations in Odoo 9 everything seems to work correctly.

Fabrice, thank you for the pointer to look into the warehouse information in the db.

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 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

1 follower(s)


Asked: 5/20/16, 6:25 PM
Seen: 404 times
Last updated: 7/7/16, 5:00 AM