{
$sql = "SELECT req.*, item.description, item.mb_flag, loc.location_name,
center.name AS WorkCentreDescription,
- (item.material_cost+item.overhead_cost+item.labour_cost) as ComponentCost,
+ item.material_cost as ComponentCost,
item.inventory_account,
- item.assembly_account
+ item.cogs_account
FROM (".TB_PREF."wo_requirements req,"
.TB_PREF."locations loc,"
.TB_PREF."workcentres center)