AnsweredAssumed Answered

Another question about Inventory

Question asked by Angelus81 on May 20, 2016
Latest reply on May 20, 2016 by Magnus Fransson

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?