Hi Shannon, Thank you for the reply. I have modified the relationship where clause, Inventory (parent) and Sparepart (child)
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 siteid=sparepart.siteid ) and :sitefiltering and siteid=:siteid
But its not working as expected, i am still able to see the spare parts for all the sites.
Issue is, In Inventory application 'where used' display tab, this tab displays all spare parts for all the sites and not for the user's default login site.
I want the requirement to be display all the spare parts according to user's default login site.
I have modified the relationship between INVENTORY (parent) and SPAREPART (child), but its not working as expected.
Should i need to modify any other relationship? Am i missing anything here?
Kindly help on this. Thanks in Advance
------------------------------
Sowndarya Seshadri
TCS
------------------------------
Original Message:
Sent: 01-15-2023 20:37
From: Shannon Rotz
Subject: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES
Hi Sowndarya: I think the problem here is that the relationship does not have a site join specified between the parent object (INVENTORY), and the child object (SPAREPART). If you add another SITEID join on the end, that should restrict it so it only shows spare parts for the same site as the Inventory record. So the new relationship Where Clause would be:
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 siteid=sparepart.siteid ) and :sitefiltering AND SITEID=:SITEID
Note: I also prefer to add a Where Used tab to the Item Master, using the original relationship, because I think it's occasionally useful for a user in a multi-site setup to be able to see what's happening with other sites. But that belongs at the Item Master level, not the Inventory level.
------------------------------
Shannon Rotz
InComm Solutions Inc.
Original Message:
Sent: 01-14-2023 02:04
From: Sowndarya Seshadri
Subject: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES
Hello everyone,
In Inventory application, Go to the "Where Used" tab. Here we could see that all spare parts assets are displayed from all the sites.
But the requirement is based on Users default login site, spare parts assets should be displayed.
When i checked there is a relationship between Inventory and Spare parts
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 siteid=sparepart.siteid ) and :sitefiltering
I have modified the above relationship as
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 siteid= (select defsite from maxuser where userid=:userid) ) and :sitefiltering
but its not working as expected. All the sites related to spare parts assets are visible.
Maximo is not taking the site into consideration when displaying the assets.
Kindly help on this requirement. Thanks in Advance.
#Customizations
#EverythingMaximo
#Inventory
------------------------------
Sowndarya Seshadri
TCS
------------------------------