What is the best method to calculate inventory level
There are many ways that product can come in and get out
Product get out in by:
Product come in by:
-return from customer
> Do I have to create Inventory table?
> How my RemainProduct field calculated to show the remaining product?