Slow-moving items (no sales in 90 days)

SELECT T0.ItemCode, T0.ItemName, T0.OnHand, T0.AvgPrice, T0.OnHand * T0.AvgPrice AS StockValue
FROM OITM T0
WHERE T0.OnHand > 0 AND NOT EXISTS (
  SELECT 1 FROM INV1 T1
  INNER JOIN OINV T2 ON T1.DocEntry = T2.DocEntry
  WHERE T1.ItemCode = T0.ItemCode AND T2.DocDate >= DATEADD(day, -90, GETDATE())
)
ORDER BY StockValue DESC

SELECT T0."ItemCode", T0."ItemName", T0."OnHand", T0."AvgPrice", T0."OnHand" * T0."AvgPrice" AS "StockValue"
FROM OITM T0
WHERE T0."OnHand" > 0 AND NOT EXISTS (
  SELECT 1 FROM INV1 T1
  INNER JOIN OINV T2 ON T1."DocEntry" = T2."DocEntry"
  WHERE T1."ItemCode" = T0."ItemCode" AND T2."DocDate" >= ADD_DAYS(CURRENT_TIMESTAMP, -90)
)
ORDER BY "StockValue" DESC