On Mar 26, 2010, at 8:46 PM, Bob Morley wrote: > What we would like to do is talk about removing statusId completely from the > inventoryItem entity and using a consistent approach regardless of the type > of inventory. This implies that the QOH/ATP would be materialized on the > inventoryItem (in practice it would only be 0 or 1 for serialized pieces) > and the accumulation would be proper based on the InventoryItemDetail. > Business logic that makes decisions based on serialized vs. non-serialized > would be brought together.
I am against removing InventoryItem.statusId: it is a good way to for example "hold" inventory (because of inspections etc...). I agree with the idea of reimplementing serialized inventory to be based (and consistent with non-serialized items) on inventoryItemDetails instead of statusId. After this change the only difference between serialized and non-serialized items will be that serialized items cannot have QOH greater than 1. Jacopo