From bb2691a9b508aaf3f75b38ca4768f6bc949c7cd5 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 17 Aug 2019 17:38:19 +0200 Subject: [PATCH] Report Sales Listing fix. --- reporting/rep106.php | 1 + 1 file changed, 1 insertion(+) diff --git a/reporting/rep106.php b/reporting/rep106.php index f9ea4499..1274a8df 100644 --- a/reporting/rep106.php +++ b/reporting/rep106.php @@ -49,6 +49,7 @@ function GetSalesmanTrans($from, $to) ".TB_PREF."salesman salesman WHERE sorder.order_no=trans.order_ AND sorder.branch_code=branch.branch_code + AND sorder.trans_type = ".ST_SALESORDER." AND branch.salesman=salesman.salesman_code AND trans.debtor_no=cust.debtor_no AND (trans.type=".ST_SALESINVOICE." OR trans.type=".ST_CUSTCREDIT.") -- 2.30.2