X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep106.php;h=4aac08ab275ad665a614d3e960c9e44c51daae63;hb=ddadb47f2620ce6902ad4694ce6512568862ba05;hp=09dd921cdb777aa18289a7a9ff020ef3e6b69d39;hpb=2b2cbcfe6a448536113966cbb11b79eda73db5ab;p=fa-stable.git diff --git a/reporting/rep106.php b/reporting/rep106.php index 09dd921c..4aac08ab 100644 --- a/reporting/rep106.php +++ b/reporting/rep106.php @@ -45,7 +45,7 @@ function GetSalesmanTrans($from, $to) AND ".TB_PREF."sales_orders.branch_code=".TB_PREF."cust_branch.branch_code AND ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code AND ".TB_PREF."debtor_trans.debtor_no=".TB_PREF."debtors_master.debtor_no - AND (".TB_PREF."debtor_trans.type=10 OR ".TB_PREF."debtor_trans.type=11) + AND (".TB_PREF."debtor_trans.type=".ST_SALESINVOICE." OR ".TB_PREF."debtor_trans.type=".ST_CUSTCREDIT.") AND ".TB_PREF."debtor_trans.tran_date>='$fromdate' AND ".TB_PREF."debtor_trans.tran_date<='$todate' ORDER BY ".TB_PREF."salesman.salesman_code, ".TB_PREF."debtor_trans.tran_date";