Very interesting thread, thanks to you all for the valuable exchange of
information.
My two cents:
* it would be great to refactor Serialized items to maintain
InventoryItemDetails records (rather than statuses) for Serialized items
and then apply the same business of non-serialized items logic for counting
QOH/ATP: this will simplify the inventory logic, simplify reporting
(including SQL based reports) maintaining all the features of Serialized
and Non-Serialized items
* as regards the back-ordered items (aka negative ATP aka deficit aka
placeholder aka virtual aka dummy inventory): maybe we could introduce a
new inventory item type ("BACKORDER" or better name) that will always have
QOH=0 and ATP<=0; it will only be used as a placeholder to store
reservations when QOH is zero; its behavior would be the same of a
Non-Serialized item and the system will create such records if not already
there (in this way there will be up to one InventoryItem of this type for
each ProductFacility record)
Regards,
Jacopo
