We have done a lot of customization to make this working but still we are unable to get through.
First we created the below relationships similar to the one existing between Inventory and Whereused
We created 3 relationships between Item and Sparepart as below:
1. name: SPAREPART
itemnum = :itemnum and itemsetid = :itemsetid
2. name: SPAREPARTASSET
itemnum = :itemnum and itemsetid = :itemsetid
3. name: SPAREPART_NOSITE
itemnum=:itemnum and itemsetid=:itemsetid and assetnum in ( select assetnum from asset where ( moved=:no or status not in (select value from synonymdomain where maxvalue in ('DECOMMISSIONED') and domainid='LOCASSETSTATUS'))) and :sitefiltering
We had to customize the whereused class in order to implement the rules as it can have 2 owners,ITEM or INVENTORY.
But once we save the item record,the record is getting disappeared on the whereused tab and we checked the sparepart table also where the record is not getting populated.
Similar behavior is observed on the Inventory application also.
Class file is also attached for the reference.
Regards
------------------------------
Mahadevan Ramakrishnan
------------------------------
Original Message:
Sent: 11-17-2021 09:26
From: Travis Herron
Subject: Introducing the whereused tab in Item Master application
Two things we did to make this work:
1) Since for us, our most important "Assets" are our buildings/facilities, every Location in the Locations table has a matching Asset. This would enable us to put data in like "this carpet Item record is used on this floor of this building" (carpet isn't used on what Maximo would traditionally call an Asset).
2) In Database Configuration, I created a custom relationship:
OBJECT: Item
CHILD OBJECT: Sparepart
WHERE CLAUSE: itemnum = :itemnum and itemsetid = :itemsetid
After that, it was pretty much just copy the XML from the Inventory application's Where Used tab, paste it into the Item Master XML at the right spot, and make sure to change the relationship on the Table Properties for the "Where Used" child table.
The only 'gotcha' I can see in this is that Inventory is at the Site level but Items are at the ItemSet level, and this is why I had to use a custom relationship -- to remove siteid from the Where Clause. For us, we only have 1 Org and 1 Site in Maximo, so it was not a problem. If you have multi-Orgs or Sites, you may have to do something more to get it how you need it.
------------------------------
Travis Herron
Pensacola Christian College
Original Message:
Sent: 11-16-2021 00:54
From: Mahadevan Ramakrishnan
Subject: Introducing the whereused tab in Item Master application
Dear All,
Could you please elucidate if any of you have implemented the whereused tab functionality in Item Master application.Currently,it is available on the inventory application and our business users have requested the same feature to be available in the Item Master application as it will help them to get the big picture instead of going to Inventory application and checking the balances per stores.
Please let me know if it is a feasible requirement and if there are any flaws of implementing this requirement on the Item Master application.
Regards,
Mahadevan
#Customizations
#EverythingMaximo
#Inventory
------------------------------
Mahadevan Ramakrishnan
------------------------------