You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by yasin lyyas <ya...@virtualvillage.com> on 2008/10/20 11:24:05 UTC
inventory item status
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
Re: inventory item status
Posted by yasin lyyas <ya...@virtualvillage.com>.
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
> >>
> >>
> >>
> >
> >
> >
Re: inventory item status
Posted by BJ Freeman <bj...@free-man.net>.
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
>>
>>
>>
>
>
>
Re: inventory item status
Posted by yasin lyyas <ya...@virtualvillage.com>.
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
>
>
>
Re: inventory item status
Posted by BJ Freeman <bj...@free-man.net>.
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.
Re: inventory item status
Posted by Mridul Pathak <mr...@hotwaxmedia.com>.
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
mridul.pathak@hotwaxmedia.com
On Mon, Oct 20, 2008 at 2:54 PM, yasin lyyas <yasin.lyyas@virtualvillage.com
> 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
>
>
Re: inventory item status
Posted by BJ Freeman <bj...@free-man.net>.
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
>
>
>
Re: inventory item status
Posted by "Jaquelynn.T" <ja...@yahoo.com>.
Hi Lyyas,
I have seen that you have some problem with the inventory item as mentioned
in your other post. Naturally it is impossible to leave it as blank. Even if
there are no more item in it, but if it is still has a ready for sale
status, then you should put the value 0 'zero', if there is no item present
in warehouse but still available for customer when they order. Or else, you
should remove it completely from the inventory. Because the item is no
longer available for customers. Or else customers will still order it and it
will cause problems.
Best Regards,
Jaquelynn.T
yasin lyyas 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
>
>
>
--
View this message in context: http://www.nabble.com/inventory-item-status-tp20065922p21569138.html
Sent from the OFBiz - User mailing list archive at Nabble.com.