X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep301.php;h=30cc9ac947d8826fca08568a08c2b49738646a79;hb=fc449c48a8d4ba23bfb18318dff08746340a440c;hp=403e4b4ba28c89ccf5947a29a870d4b589b4989b;hpb=6b30619eff8469a679e7c18a19b6df7091417128;p=fa-stable.git diff --git a/reporting/rep301.php b/reporting/rep301.php index 403e4b4b..30cc9ac9 100644 --- a/reporting/rep301.php +++ b/reporting/rep301.php @@ -105,8 +105,8 @@ function getTransactions($category, $location, $date) item.description, item.inactive, move.loc_code, SUM(move.qty) AS QtyOnHand, - item.material_cost + item.labour_cost + item.overhead_cost AS UnitCost, - SUM(move.qty) *(item.material_cost + item.labour_cost + item.overhead_cost) AS ItemTotal + item.material_cost AS UnitCost, + SUM(move.qty) * item.material_cost AS ItemTotal FROM " .TB_PREF."stock_master item," .TB_PREF."stock_category category,"