Overhead and labour cost changed to define standard costs.

[fa-stable.git] / reporting / rep301.php

diff --git a/reporting/rep301.php b/reporting/rep301.php
index 0c8ce806551d3fa839741ea3f2a7faccb4f0ab35..30cc9ac947d8826fca08568a08c2b49738646a79 100644 (file)
--- a/reporting/rep301.php
+++ b/reporting/rep301.php
@@ -105,15 +105,15 @@ 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,"
                        .TB_PREF."stock_moves move
                WHERE item.stock_id=move.stock_id
                AND item.category_id=category.category_id
-               AND item.mb_flag<>'D' 
+               AND item.mb_flag<>'D' AND mb_flag <> 'F' 
                AND move.tran_date <= '$date'
                GROUP BY item.category_id,
                        category.description, ";