Query For AVG Price
SELECT Distinct T0.[ItemCode], T0.[DfltWH], T0.[AvgPrice], T0.[OnHand]
FROM OITM T0
WHERE (T0.[AvgPrice]is Null or T0.[AvgPrice] = '0') and T0.[OnHand]>=0 and
T0.ByWH ='N' and T0.EvalSystem <> 'F'
Union ALL
SELECT Distinct T0.[ItemCode], T0.[WhsCode], T0.[AvgPrice], T0.[OnHand]
FROM OITW T0
INNER JOIN OITM T1 on T0.ItemCode = T1.ItemCode
WHERE ( T0.[AvgPrice]is Null or T0.[AvgPrice] = '0') and
T0.[OnHand]>=0 and T1.ByWH = 'y' and T1.EvalSystem <> 'F'
Bluesky
