Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
133 Visualizzazioni

Hello Team,

I have implemented ans Odoo on-premise POS system. After sales, I wish to generate a stock report for all my products, and their bill of materials, with the following information :

  • Quantities in Stock : Stock left
  • Quantities Sold : Via POS
  • Quantities purchased (if any) : For any replenishment that will occur


For example : I have two products : "Bread" and "Banana"
- Bread has as bill of material : Butter, milk, flour, sugar. Hence it undergoes a Manufacturing process.
Therefore, once a quantity of Bread will be sold/consumed, it will be together with butter, milk, flour and sugar.


Hence I want to track the QTY LEFTQTY SOLD and QTY Purchased (if any) of banana, bread, butter, milk, sugar.


Please is it possible to generate such report ? If yes, How ?
Thanks in advance.

Avatar
Abbandona
Risposta migliore

If you navigate to Inventory > Reporting > Stock and filter by Incoming OR outgoing greater than '0' would list all products that had a transaction. 

Outgoing would include sales + consumed by BoM and Incoming includes purchased + produced.

I think that is what you mean in your example.. Bread was produced and sold, while butter, milk, sugar was purchased and consumed.

My apologies if I haven't understood your question correctly.

Avatar
Abbandona
Autore

Hello Jaideep,
The Outgoing column is for quantities ready to be consumed (Either Sales or Manufacture process), once consumed, outgoing column gets back to zero
Same for incoming, it represents quantities in process to be inserted from replenishment, once inserted it gets back to zero.
I think this has nothing to do with Quantities sold, produced or sold.

Risposta migliore

Hi,

Please refer to the module: https://apps.odoo.com/apps/modules/18.0/pos_product_stock


Hope it helps.

Avatar
Abbandona
Autore

Hello @cybrocys
Thanks for your feedback but I meant these information in a report (default odoo report template)

Secondly, want to see both QTY in Stock, QTY sold and QTY purchased.

If I can't have these once in a report, how then can I track these and be able to add them in my Stock report please ?