X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep304.php;h=971c7e20553c246bd79625f6e9724f27e23f9125;hb=842d2d6eddb907d77d14630a5b7b25608fb31b5d;hp=28297c5825f23c33a37840afd9b0a0b2cb27469f;hpb=6b30619eff8469a679e7c18a19b6df7091417128;p=fa-stable.git diff --git a/reporting/rep304.php b/reporting/rep304.php index 28297c58..971c7e20 100644 --- a/reporting/rep304.php +++ b/reporting/rep304.php @@ -45,7 +45,7 @@ function getTransactions($category, $location, $fromcust, $from, $to, $show_serv move.tran_date, SUM(-move.qty) AS qty, SUM(-move.qty*move.price) AS amt, - SUM(-IF(move.standard_cost <> 0, move.qty * move.standard_cost, move.qty *(item.material_cost + item.labour_cost + item.overhead_cost))) AS cost + SUM(-IF(move.standard_cost <> 0, move.qty * move.standard_cost, move.qty *item.material_cost)) AS cost FROM ".TB_PREF."stock_master item, ".TB_PREF."stock_category category, ".TB_PREF."debtor_trans trans,