This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Here's one that has us stumped. . . . v7, Inventory items that require inspection are received into a Holding location and then transferred to a Storeroom after inspection. How can you query for items currently located in the HOLDING location?
Makes sense they would be in Inventory, the HOLDING location with a status of WINSP, but no joy.
Mack P
Projetech
Mack,
Is there a reason you are looking for them in inventory rather than reciving? In reciving it is easy to look for the WINSP status items. The logic I see is they are not fully received until inspected and thus not truly in inventory when in WINSP. But I can see the cases where having them show in the holding location as inventory would also be useful.
Andy
--- In MAXIMO@yahoogroups.com, "emppdei" <mparrott@...> wrote:
>
> Here's one that has us stumped. . . . v7, Inventory items that require inspection are received into a Holding location and then transferred to a Storeroom after inspection. How can you query for items currently located in the HOLDING location?
>
> Makes sense they would be in Inventory, the HOLDING location with a status of WINSP, but no joy.
>
> Mack P
> Projetech
>
Andy,
My hunch is that over the years some items will inadvertently not be inspected resulting in incomplete receipts. Was hoping to build a simple saved query that the users can launch periodically to see what's out there.
Mack
--- In MAXIMO@yahoogroups.com, "andrew.tess" <atess@...> wrote:
>
> Mack,
> Is there a reason you are looking for them in inventory rather than reciving? In reciving it is easy to look for the WINSP status items. The logic I see is they are not fully received until inspected and thus not truly in inventory when in WINSP. But I can see the cases where having them show in the holding location as inventory would also be useful.
>
> Andy
>
> --- In MAXIMO@yahoogroups.com, "emppdei" <mparrott@> wrote:
> >
> > Here's one that has us stumped. . . . v7, Inventory items that require inspection are received into a Holding location and then transferred to a Storeroom after inspection. How can you query for items currently located in the HOLDING location?
> >
> > Makes sense they would be in Inventory, the HOLDING location with a status of WINSP, but no joy.
> >
> > Mack P
> > Projetech
> >
>
Mack
We use an escalation to send a notification to the user if an item is in the
holding for 15 days are and requires action. You could modify the query and
have them save it in the PO application.
historyflag = 0
and (exists (select 1 from matrectrans where status in ('WINSP','WASSET')
and transdate < sysdate - 15
and po.siteid = matrectrans.siteid and po.ponum = matrectrans.ponum)
or
exists (select 1 from servrectrans where status = 'WINSP' and transdate <
sysdate - 15
and po.siteid = servrectrans.siteid and po.ponum = servrectrans.ponum))
Kevin
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
emppdei
Sent: Wednesday, May 23, 2012 2:36 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Items WINISP
Andy,
My hunch is that over the years some items will inadvertently not be
inspected resulting in incomplete receipts. Was hoping to build a simple
saved query that the users can launch periodically to see what's out there.
Mack
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"andrew.tess" <atess@...> wrote:
>
> Mack,
> Is there a reason you are looking for them in inventory rather than
reciving? In reciving it is easy to look for the WINSP status items. The
logic I see is they are not fully received until inspected and thus not
truly in inventory when in WINSP. But I can see the cases where having them
show in the holding location as inventory would also be useful.
>
> Andy
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"emppdei" <mparrott@> wrote:
> >
> > Here's one that has us stumped. . . . v7, Inventory items that require
inspection are received into a Holding location and then transferred to a
Storeroom after inspection. How can you query for items currently located in
the HOLDING location?
> >
> > Makes sense they would be in Inventory, the HOLDING location with a
status of WINSP, but no joy.
> >
> > Mack P
> > Projetech
> >
>