Maximo Open Forum

 View Only
  • 1.  Introducing the whereused tab in Item Master application

    Maximo Certified
    Posted 11-16-2021 00:54
    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
    ------------------------------


  • 2.  RE: Introducing the whereused tab in Item Master application

    Posted 11-17-2021 09:27
    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
    ------------------------------



  • 3.  RE: Introducing the whereused tab in Item Master application

    Maximo Certified
    Posted 11-17-2021 23:25
    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
    ------------------------------



  • 4.  RE: Introducing the whereused tab in Item Master application

    Maximo Certified
    Posted 11-17-2021 23:27
    Class files which are customized are attached for the reference.

    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------

    Attachment(s)

    txt
    WhereUsedSetRemoteExt.txt   172 B 1 version
    txt
    WhereUsedExt.txt   2 KB 1 version
    txt
    WhereUsedSetExt.txt   10 KB 1 version


  • 5.  RE: Introducing the whereused tab in Item Master application

    Posted 11-18-2021 09:16
    Ours works, and we didn't have to do any class file customizations.

    I don't understand why you made two relationships with the same WHERE Clause.

    Most importantly, on the ITEM.XML file, how is the table configured?  Check your relationship, data source name, and control ID.


    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------



  • 6.  RE: Introducing the whereused tab in Item Master application

    Maximo Certified
    Posted 11-18-2021 14:53
    I have successfully solved the issue . It required mbo and bean class customization