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.
We have criteria that all A items must be counted once every 90 days, B's once every 180 days and C's once every 365 days. We then use 3 saved queries in the Inventory module to find Items that do not meet that criteria. One for each of the types. The stores folks can then use the download function of the list to create a spreadsheet they can work from. Even better they can use a laptop and just go count those items.
The saved query to find the items looks like this:
WHERE (abctype like 'A') and (exists (select itemnum from pzmax.invbalances where ((physcntdate <sysdate - 90)) and (itemnum = inventory.itemnum and itemsetid = inventory.itemsetid and siteid = inventory.siteid and location=inventory.location)))
You would then just substitute the A and 90 with the other values to get the correct query.
The hard part is getting and staying on track. I suggest you do a count of how many A, B and C items you have. Then each week you count 1/12th of the A's, 1/26th of the B's and 1/52nd of the C's. If you do that all you're a's are up to date after 90 days, your B's after 180 days and your C's after a year. If you keep it up everything stays up to date. It makes for a sustainable process.
Dave Teece
Reliability Analyst / CMMS Support, CMRP