Report Sales Listing fix.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Sat, 17 Aug 2019 15:38:19 +0000 (17:38 +0200)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Sat, 17 Aug 2019 15:38:19 +0000 (17:38 +0200)
reporting/rep106.php

index f9ea4499eaa518989504200dc95017dd4ee467fe..1274a8df9cb94b4018c63e7f1940b2cafbb9ef3b 100644 (file)
@@ -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.")