X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep106.php;h=1274a8df9cb94b4018c63e7f1940b2cafbb9ef3b;hb=13fae1ba1d78cff66e326a006be2f538dd404248;hp=f9ea4499eaa518989504200dc95017dd4ee467fe;hpb=d1babda7c01b314d35fb89f2d195553b55936532;p=fa-stable.git 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.")