X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep301.php;h=e2e568c875ca3a063472bca75cab677348c86390;hb=33dfc21a26f08e9ac19048bbcf80cce2351a6cfe;hp=fe8b58e743a9480ee840c37aad03ea6f99f5ff84;hpb=5e63c6ace55729bbb5ee3b060035a25a4426eb0a;p=fa-stable.git diff --git a/reporting/rep301.php b/reporting/rep301.php index fe8b58e7..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;