X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep308.php;h=97ce87e3efc42a1b799eaa1ea98d34964a0b0024;hb=fec081ddbcf4f2ceb4b325f30cfc1005e855b724;hp=0631e46dba74f0a1535d9a7e45dfa31718831eac;hpb=01dd975d5588641f9b56ae26bd112d4d9ba31783;p=fa-stable.git diff --git a/reporting/rep308.php b/reporting/rep308.php index 0631e46d..97ce87e3 100644 --- a/reporting/rep308.php +++ b/reporting/rep308.php @@ -115,7 +115,7 @@ function avg_unit_cost($stock_id, $location=null, $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; @@ -157,7 +157,7 @@ function trans_qty_unit_cost($stock_id, $location=null, $from_date, $to_date, $i $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, tran_date, 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; @@ -318,4 +318,3 @@ function inventory_movements() $rep->End(); } -?> \ No newline at end of file