inventory item status
Locked
 
|
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 |
|
|
1) not sure what process would leave the statusid null
it would be _NA_ what service(s) are you using. what steps did you do to get to this point. 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 > > > |
|
|
In reply to this post by Yasin Lyyas
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. -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [hidden email] On Mon, Oct 20, 2008 at 2:54 PM, yasin lyyas <[hidden email] > wrote: > 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 > > |
|
|
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. |
|
|
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 > > > |
|
|
which rev are you using
have you changed anything else that might effect the information based on last rev look at InventoryServices.checkInventoryAvailability about line 401. this will tell you the criteria used. yasin lyyas sent the following on 10/22/2008 1:26 AM: > 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 >> >> >> > > > |
|
|
Hi,
thanks for your reply, I have checked it and the problem is clear to me now. Thanks a lot. Lyyas Yasin On Wed, 2008-10-22 at 03:53 -0500, BJ Freeman wrote: > which rev are you using > have you changed anything else that might effect the information > > based on last rev > look at InventoryServices.checkInventoryAvailability > about line 401. > this will tell you the criteria used. > > > yasin lyyas sent the following on 10/22/2008 1:26 AM: > > 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 > >> > >> > >> > > > > > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |