From a9922b1495a13b95c3fbba2c5f7c221cef5445f8 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 29 Nov 2016 16:19:27 +0100 Subject: [PATCH] =?utf8?q?Fixed=C2=A0A=20Bug=20in=20Item=20Sales=20Summary?= =?utf8?q?=20Report?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- reporting/rep309.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep309.php b/reporting/rep309.php index 1bb9ba06..17203424 100644 --- a/reporting/rep309.php +++ b/reporting/rep309.php @@ -50,7 +50,7 @@ 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 (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, -- 2.30.2