This is for our coffee business app
We take raw coffee and roast them
Let's say on Monday we roasted 5 Kg of coffee and that equals 20 bags of coffee, And we sold 18 bags that day.
On Tuesday we again roasted 5 Kgs, but now we want the inventory to carry forward the 2 remaining bags from Monday. it should show 22 Bags available.
We have two separate tables. One for Production, and one for sale.
Please suggest how we can go ahead. If you require anymore information/ explanation you can let me know
Current inventory = production_qty - sales_qty
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |