Fixed A Bug in Item Sales Summary Report

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

diff --git a/reporting/rep309.php b/reporting/rep309.php
index a306a4330fab62e4a630f95fbf31b7a97d04c2c9..6b769bf322a37ca822eb846aa9d51c11a28351ae 100644 (file)
--- a/reporting/rep309.php
+++ b/reporting/rep309.php
@@ -50,7 +50,8 @@ function getTransactions($category, $from, $to)
                AND trans.tran_date>='$from'
                AND trans.tran_date<='$to'
                AND line.quantity<>0
-               AND line.debtor_trans_type = ".ST_SALESINVOICE;
+               AND item.mb_flag <>'F'
+               AND (line.debtor_trans_type = ".ST_SALESINVOICE." OR line.debtor_trans_type = ".ST_CUSTCREDIT.")";
                if ($category != 0)
                        $sql .= " AND item.category_id = ".db_escape($category);
                $sql .= " GROUP BY item.category_id,
@@ -113,8 +114,6 @@ function print_inventory_sales()
 
        $res = getTransactions($category, $from, $to);
        $total = $grandtotal = 0.0;
-       $total1 = $grandtotal1 = 0.0;
-       $total2 = $grandtotal2 = 0.0;
        $catt = '';
        while ($trans=db_fetch($res))
        {
@@ -128,7 +127,7 @@ function print_inventory_sales()
                                $rep->Line($rep->row - 2);
                                $rep->NewLine();
                                $rep->NewLine();
-                               $total = $total1 = $total2 = 0.0;
+                               $total = 0.0;
                        }
                        $rep->TextCol(0, 1, $trans['category_id']);
                        $rep->TextCol(1, 7, $trans['cat_description']);