By any chance, are these items rotating? Looking at the MATRECTRANS relationship for INVENTORY, the out of the box relationship (in 9.1) is this: itemnum=:itemnum and itemsetid=:itemsetid and ((issuetype in (select value from synonymdomain where domainid ...

You'd have to also look at the MATRECTRANS.ISSUETYPE field for the transaction. Several Types would have NULLs for the FROMSTORELOC, such as INVOICE, RECEIPT, RETURN, VOIDRECEIPT, etc. Other transaction types, such as TRANSFER, KITBREAK, or KITMAKE, ...

Hi Steven, Thank you for your reply! What you say makes sense. I guess I'm just trying to figure out why a transaction would have a blank value in the FROMSTORELOC and then have a different storeroom (not the storeroom I'm currently on) in TOSTORELOC. ...

Does anyone have screenshots of Assets, Job Plans, PMs, and Work Orders in MAS 9 that use Maximo Reliability Strategies? #MaximoApplicationSuite ------------------------------ Stevie Holloway Tufts University ------------------------------

I'm not sure I understand the request. The inventory transactions are everything inbound or outbound from the storeroom so for every transaction, the storeroom you're on should be listed as either the FROM or the TO location. If your storeroom is CENTRAL ...