X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_order_requirements_db.inc;h=090c8c548abc3a0dc0089833631ef132b2641691;hb=d907208297556310cc7c51fcb9086869c880ab2d;hp=395ad6534b1aa4298d4565cfc301968b4c3e3c8f;hpb=50d1a68af70dfcadbb3896798e8211881457e3fa;p=fa-stable.git diff --git a/manufacturing/includes/db/work_order_requirements_db.inc b/manufacturing/includes/db/work_order_requirements_db.inc index 395ad653..090c8c54 100644 --- a/manufacturing/includes/db/work_order_requirements_db.inc +++ b/manufacturing/includes/db/work_order_requirements_db.inc @@ -13,9 +13,9 @@ function get_wo_requirements($woid) { $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)