- $sql = "SELECT material_cost + labour_cost + overhead_cost AS std_cost
- FROM ".TB_PREF."stock_master WHERE stock_id=".db_escape($stock_id);
+ $sql = "SELECT IF(s.type='D', 0, material_cost + labour_cost + overhead_cost) AS std_cost
+ FROM ".TB_PREF."stock_master s WHERE stock_id=".db_escape($stock_id);