$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;
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'];
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;