Hi, thanks for the reply. The Inventory is a non-serialized inventory. Also, we edit something in service to process returned item so that the InventoryItem StatusId will be set to null. I know this should not be done this way, but it has been done now and its in production server. I just need a clarify that, a blank InventoryItem status id will not give us problem with a reservation made to this InventoryItem.
On Wed, 2008-10-22 at 03:09 -0500, BJ Freeman wrote: > there is a > INV_NON_SER_STTS group as well > as well > and if a new InventoryItem is created is should have _NA_ till either > one of then INV_NON_SER_STTS or INV_SERIALIZED_STTS are assigned. > this is so views that include Status will show. > > Mridul Pathak sent the following on 10/22/2008 12:32 AM: > > AFAIK, Inventory Item Status are used only in case of serialized inventory, > > and not for non-serialized ones. So in case of non-serialized inventory > > items you may find blank inventory item status. yasin lyyas sent the following on 10/20/2008 2:24 AM: > Hi all, > > I have a question here regarding the inventory item status id. If the > status id is blank (null), what will happen if there is a reservation > made to this inventory item? In our case, we have a returned inventory > item. Status ID for this inventory item has been removed ( becomes > blank), and it has 10 qoh and atp. When a reservation made to this > inventory item, the order becomes a backorder. atp/qoh is 9/10, but in > reservation table, it shows the qty not available = 1. > > Can we not leave the inventory item status blank? > > Thanks > > Lyyas > Yasin > > >
