function fetch_items($category=0)
{
$sql = "SELECT item.stock_id, item.description AS name,
- item.material_cost+item.labour_cost+item.overhead_cost AS Standardcost,
+ item.material_cost AS Standardcost,
item.category_id,item.units,
category.description
FROM ".TB_PREF."stock_master item,
WHERE item.category_id=category.category_id AND NOT item.inactive";
if ($category != 0)
$sql .= " AND category.category_id = ".db_escape($category);
- $sql .= " ORDER BY item.category_id,
+ $sql .= " AND item.mb_flag<> 'F' ORDER BY item.category_id,
item.stock_id";
return db_query($sql,"No transactions were returned");