Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda

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
Buang
Penulis

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.

Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
1
Okt 22
2921
2
Agu 24
2784
3
Feb 24
4882
1
Jun 23
3022
4
Apr 25
8923