X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep301.php;h=30cc9ac947d8826fca08568a08c2b49738646a79;hb=fc449c48a8d4ba23bfb18318dff08746340a440c;hp=0c8ce806551d3fa839741ea3f2a7faccb4f0ab35;hpb=f44132511cc91b83f20f91af0625d4b112b4c26e;p=fa-stable.git

diff --git a/reporting/rep301.php b/reporting/rep301.php
index 0c8ce806..30cc9ac9 100644
--- 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, ";