Ir al contenido
Menú
Se marcó esta pregunta
4 Respuestas
7114 Vistas

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 with zero stock quantity? If the source code need to be changed, can you give me some pointers of where I should look (which files)? Thank you.
Simon Lee

Avatar
Descartar
Mejor respuesta

In stock_account module there is written action  product_valuation_action and a domain passed 

<field name="domain">[('type', '=', 'product'), ('qty_available', '!=', 0)]</field>​
if you change that domain for qty_available it will show for all products.
Avatar
Descartar
Autor Mejor respuesta

Thank you very much. Will try.

Simon

Avatar
Descartar
Mejor respuesta

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.

Avatar
Descartar
Mejor respuesta

any idea how to do it in odoo 14?

Avatar
Descartar

did you find the solution?

No, not yet. 

El jue, 27 ene 2022 a la(s) 12:57, Jahir (jahir@layan.mx) escribió:

did you find the solution?


Enviado por Odoo S.A. usando Odoo.



--
CLemMy H.C.