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. T

Hi, Please refer to the module: https://apps.odoo.com/apps/modules/18.0/pos_product_stock [1] Hope it helps. [1] https://apps.odoo.com/apps/modules/18.0/pos_product_stock

Track Stock POS Stock

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Apskaita
Atsarga
PoS
Project
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

Track Stock POS Stock

2 Replies

161 Rodiniai

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.

Jaideep

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.

Arsene Demenou

Autorius

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

Not entirely, incoming and outgoing include qty sold / consumed with BoM- delivered and yet to be delivered, while incoming includes purchased yet to receive; already received and produced by MO. It also includes inventory adjustments and scraps, which update On hand qty. These fields does not reset to 0

They are sum of product qty from all stock moves

You would be able to view details of the moves by clicking History (to the right end of each row). Do remove the done filter to view all moves.

In your post you mention PoS, where the stock moves are posted end of session, if the functionality of delivery later isn’t in use there wouldn’t be product reservations (sold yet to be delivered)

On hand qty is qty left, while Free to Use is On hand qty - qty reserved

My reference here is to stock report in Inventory app

Inventory > Reporting > Stock