X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep301.php;h=e2e568c875ca3a063472bca75cab677348c86390;hb=33dfc21a26f08e9ac19048bbcf80cce2351a6cfe;hp=9d2b83bae24da5a40723db8748892bbb91f142ae;hpb=01dd975d5588641f9b56ae26bd112d4d9ba31783;p=fa-stable.git

diff --git a/reporting/rep301.php b/reporting/rep301.php
index 9d2b83ba..e2e568c8 100644
--- a/reporting/rep301.php
+++ b/reporting/rep301.php
@@ -66,7 +66,7 @@ function getAverageCost($stock_id, $to_date)
 
 	$to_date = date2sql($to_date);
 
-	$sql = "SELECT standard_cost, price, tran_date, type, trans_no, qty, person_id FROM ".TB_PREF."stock_moves
+	$sql = "SELECT standard_cost, qty FROM ".TB_PREF."stock_moves
 		WHERE stock_id=".db_escape($stock_id)."
 		AND tran_date <= '$to_date' AND standard_cost > 0.001 AND qty <> 0 AND type <> ".ST_LOCTRANSFER;
 
@@ -133,7 +133,7 @@ function getTransactions($category, $location, $date)
 
 function print_inventory_valuation_report()
 {
-    global $path_to_root, $use_costed_values;;
+    global $path_to_root, $SysPrefs;
 
 	$date = $_POST['PARAM_0'];
     $category = $_POST['PARAM_1'];
@@ -211,7 +211,7 @@ function print_inventory_valuation_report()
 			if ($detail)
 				$rep->NewLine();
 		}
-		if (isset($use_costed_values) && $use_costed_values==1)
+		if (isset($SysPrefs->use_costed_values) && $SysPrefs->use_costed_values==1)
 		{
 			$UnitCost = getAverageCost($trans['stock_id'], $date);
 			$ItemTotal = $trans['QtyOnHand'] * $UnitCost;
@@ -258,4 +258,3 @@ function print_inventory_valuation_report()
     $rep->End();
 }
 
-?>
\ No newline at end of file