Hi What is the best query to truncae A_WORKORDER in DB2 to create space in the storage How can if ind size of the table. Regards Naveed #Administration ------------------------------ Naveed Wasay Serco -------------------------- ...

Hi Stevie, Hope these screenshots are good. Best regards Anneli ------------------------------ Anneli Dolff Asset Management, Nexer AB ------------------------------

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. ...