How to display stock item with zero quantity in inventory report

Question

Hi All,
I am using odoo 12 community edition. I would like to show all inventory items in our warehouses with the inventory report including stock with zero quantity. How can I do that?
I used the following to show the report: Inventory --> Reporting --> Inventory Report --> Current Inventory --> Retrieve the Inventory Quantities. Using the "View pivot" option to view the report, the items with zero stock quantity do not appear on the report. Does anyone know how I can display also the items wit

Ajeet Yadav (Softprime Consulting Pvt Ltd) · Accepted Answer

In stock_account module there is written action *product_valuation_action *and a domain passed [('type', '=', 'product'), ('qty_available', '!=', 0)] if you change that domain for qty_available it will show for all products.

Simon Lee · Answer

Thank you very much. Will try.
Simon

Nathan Morris · Answer

I find that the best way to get a complete count, including zero values, is to go to Products

--> Products, and
then you can choose the list view option and choose the filters to get the products you want to view, irrigardless of their stock value.  When doing this method ensure that you don't have any conflicting figures on the "update quantity" page for each product.
Hope this helps.

Breezee Online S de RL de CV · Answer

any idea how to do it in odoo 14?

This question has been flagged

Enjoying the discussion? Don't just read, join in!