Pull Latest inventory data

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

 

0 1 43
1 REPLY 1

Current inventory = production_qty - sales_qty

Top Labels in this Space