Because items are 'received' but not 'commited' until Supplier Invoice is in hand it creates floor/computer Quantity differences that may effect a sale. There is a 'received-but-not-commited' column in the PurchaseOrderEntry table called 'quantityReceived' which couldbe added to QuantityOnHand to give a true 'on-the-floor' Value. In a HQ environment when 'checking stores' it could be either added to QuantityOnHand or Shown as 'Rcvd-Not-Commited'. In any multi-store operation, knowing the other store qtys (Quickly/Accurately) can mean getting or losing a sale. Another 'design-bug' is that 'check-stores' reports HQ's Qtys of the store making the request and should report the 'current' qty in the requesting store which can always be seen.
- posted
16 years ago