Skip to Content
Menu
This question has been flagged

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

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.

Best Answer

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
Discard
Related Posts Replies Views Activity
1
Oct 22
2055
2
Aug 24
1581
3
Feb 24
2353
1
Jun 23
2086
4
Apr 25
5654