SUM(move.qty) AS QtyOnHand,
item.material_cost AS UnitCost,
SUM(move.qty) * item.material_cost AS ItemTotal
FROM "
.TB_PREF."stock_master item,"
.TB_PREF."stock_category category,"
SUM(move.qty) AS QtyOnHand,
item.material_cost AS UnitCost,
SUM(move.qty) * item.material_cost AS ItemTotal
FROM "
.TB_PREF."stock_master item,"
.TB_PREF."stock_category category,"