Q.Non Moving Item last 30 Days Warehouse Wise ?

ANS:-
Select T.ItemCode,T.ItemName, T0.Onhand, T0.WhsCode
From OITM T
Inner Join OITW T0 on T0.Itemcode = T.ItemCode
where not exists (Select T0.ItemCode FROM OINM T0
   WHERE T0.ItemCode =T.ItemCode
       and  T0.DocDate > getdate()-30) and

T0.WhsCode
 IN ('I_POSTIH','I_PREIH','OSP060','FG_IMT')AND T0.OnHand<>'0'