Inventory Analysis

×
SELECT     
IM.item_no AS [Item No]
, IM.item_desc_1 AS [Description 1]
, IM.item_desc_2 AS [Description 2]
, IL.qty_on_hand * IL.Avg_cost AS [Value on Hand]
, IL.qty_on_hand AS [Qty On Hand]
, IL.Avg_Cost AS [Avg Cost]
, IL.sls_ytd AS [Sales YTD]
FROM IMITMIDX_SQL IM
INNER JOIN IMINVLOC_SQL IL ON IM.item_no = IL.item_no AND IM.item_filler = IL.item_filler
WHERE     (IL.qty_on_hand * IL.Avg_cost <> 0)
OR Sls_Ytd<>0
ORDER BY IL.qty_on_hand * IL.Avg_cost DESC