Items Having Current Cost and No Movement

At time you want to audit the inventory items which are having Current Cost and no Movement (these items normally exist in GP during the migration process or upgrade process from the old system), below query gives you the list of such items in GP. The listed items are safe to delete from the system if they are not really required (delete at you own risk).

SELECT LTRIM(RTRIM(IV00101.ITEMNMBR)) as ITEMNMBR, IV00101.STNDCOST, IV00101.CURRCOST, IV00102.QTYONHND
FROM IV00101 INNER JOIN IV00102 ON IV00101.ITEMNMBR = IV00102.ITEMNMBR
WHERE    (IV00102.RCRDTYPE = 1) AND (IV00102.QTYONHND = 0) AND (IV00101.CURRCOST > 0)
    AND IV00101.ITEMNMBR NOT IN (select distinct(itemnmbr) from IV30300)
Come back for more tips ..... J