Ir al contenido
Menú
Se marcó esta pregunta

good evening

I would like to know how to obtain a summary table of the stock history, the table should display the initial stock, the entries, the exits, and the final stock.

thank you

Odoo 17

Avatar
Descartar
Autor

thank you for your response

actually, I would like to have a summary table in which I would have the total of entries, the total of exits, and the final stock for the month of September, for example.

Mejor respuesta

Hello aboubakr

To obtain a summary table of stock history in Odoo 17, showing the initial stock, entries, exits, and final stock for your products, you can use the Inventory Reports in Odoo or customize it through a query. Here's a step-by-step guide:

  1. Go to Inventory App:
    • Navigate to Inventory > Reporting > Inventory Valuation or Inventory > Reporting > Stock Moves.
  2. Filter by Date and Group By Product:
    • In the Inventory Valuation report, set the appropriate date range for which you want the summary.
    • Group the data by Product to view each product’s stock movements.
  3. Check the Stock Quantities:
    • The report will display the initial stock (starting balance), entries (purchases, manufacturing, etc.), exits (sales, transfers), and final stock (ending balance).
    • You can export this data into Excel if needed for further analysis or reporting.

Let me know if this helps :)

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
oct 22
2649
2
ago 24
2355
3
feb 24
4020
1
jun 23
2800
4
abr 25
7766