From: Joe Hunt Date: Sat, 17 Aug 2019 15:38:19 +0000 (+0200) Subject: Report Sales Listing fix. X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=bb2691a9b508aaf3f75b38ca4768f6bc949c7cd5 Report Sales Listing fix. --- 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.")