Tax Inquiry: fixed refrences to non-existing database fields.

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

diff --git a/reporting/rep301.php b/reporting/rep301.php
index 953bafcad3544903091020f04260ae9f392fa8e0..e2e568c875ca3a063472bca75cab677348c86390 100644 (file)
--- 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;