Odoo Help


Qty Available Not Calculating Properly

Jeffrey Russell
on 5/20/16, 6:25 PM 982 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.

On 3/16/17, 4:47 AM

 Go To Inventory App - Warehouse Management - Location - Choose Your Product location then set the Parent Location with your default selling warehouse

you can see the default selling warehouse when create sale order - Other Information - see the warehouse field below Shipping Information

I know my answer is too late..but it can help the other who have the same problem like me before

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: 982 times
Last updated: 3/16/17, 4:47 AM