A standard structures between customers and a company should be:
Inventory --< LineItem >-- Order >--- customers
But how about from vender side? As a company I need to order goods from vender as well. So supposedly, it should be appeared as:
Vender --< PO --< LineItem >-- Inventory
However, I am concern about my on hand quantity.
Say I order 100 pieces of candies, but I cannot enter it directly to the PO LineItem because it will immediately reflect my on hand qty. Whereas, I am still waiting the candies to be delivered to me. Besides, what if my vender cannot deliver 100 pieces of candies at once? What if they only deliver 50 pieces of candies first and deliver another 50 a week later?
What should I do to solve this problem?
I am thinking that I should create another table called "Bill" somewhere between the PO and Inventory, but I do not know what exactly I need to do.
Can anyone give me some advices?