Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
2 Antwoorden
172 Weergaven
Avatar
Arsene Demenou

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 LEFT, QTY 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
Annuleer
Avatar
Jaideep
Beste antwoord

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
Annuleer
Arsene Demenou
Auteur

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.

Jaideep

Sorry my bad, yes that is correct the Incoming and Outgoing are expected deliveries and receipts. Once they are received or delivered the On hand qty is updated and these turn back to 0.

The moves history/ analysis is probably a better indicator of qty incoming and outgoing. But this wouldn't have the On hand qty.

On hand qty is at a particular date while sold/ produced and purchased are for a date range, so not sure how they would work on a report?

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Beste antwoord

Hi,

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


Hope it helps.

Avatar
Annuleer
Arsene Demenou
Auteur

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 ?