yes thank you I have used next stament and the issue solved
update MATRECTRANS
SET SITEID =
(Select L.SITEID FROM LOCATIONS L WHERE L.TYPE = 'STOREROOM' AND MATRECTRANS.TOSTORELOC = L.LOCATION AND MATRECTRANS.SITEID != L.SITEID)
where issuetype = 'RECEIPT' AND EXISTS
(Select 1 FROM LOCATIONS L WHERE L.TYPE = 'STOREROOM' AND MATRECTRANS.TOSTORELOC = L.LOCATION AND MATRECTRANS.SITEID != L.SITEID
------------------------------
nasr buzaid
eni
------------------------------
Original Message:
Sent: 07-30-2025 09:39
From: Nancy Lerner
Subject: there is data in database but doesn't appeared on maximo
Nasr, your screen shot of Maximo shows that you are looking at the transactions for a specific inventory record. Your SQL query is pulling all transactions for the specified item number. If you look at the TOSTORELOC values for the records pulled by the SQL statement, you will likely find that there are no records referring to the storeroom for which you are viewing the inventory record. The inventory application will only show you MATRECTRANS records that involve that specific inventory record (same item and storeroom).
------------------------------
Nancy Lerner
Brio Consulting
Original Message:
Sent: 07-29-2025 15:00
From: nasr buzaid
Subject: there is data in database but doesn't appeared on maximo
#Inventory
------------------------------
nasr buzaid
eni
------------------------------