From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Tue, 29 Nov 2016 15:20:32 +0000 (+0100)
Subject: Fixed A Bug in Item Sales Summary Report
X-Git-Tag: v2.4.2~19^2~29
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=840f9a44261cdf4ee95a5cc9a29314b9ddb06b9c

Fixed A Bug in Item Sales Summary Report
---

diff --git a/reporting/rep309.php b/reporting/rep309.php
index f52dc22a..6b769bf3 100644
--- a/reporting/rep309.php
+++ b/reporting/rep309.php
@@ -51,7 +51,7 @@ function getTransactions($category, $from, $to)
 		AND trans.tran_date<='$to'
 		AND line.quantity<>0
 		AND item.mb_flag <>'F'
-		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,