X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=reporting%2Frep102.php;h=18fab24d052952aa6649e80e8064fde507fec187;hb=ef5133a65092c38f70278a2ed22952e3625855dc;hp=2d00c063f1573e637498bb2e094892f1aa6ed8ac;hpb=a82e9b552d49b11dad1c726a23bfa958463a5154;p=fa-stable.git diff --git a/reporting/rep102.php b/reporting/rep102.php index 2d00c063..18fab24d 100644 --- a/reporting/rep102.php +++ b/reporting/rep102.php @@ -51,11 +51,9 @@ function get_invoices($customer_id, $to, $all=true) IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $PastDueDays2,$value,0) AS Overdue2 FROM ".TB_PREF."debtors_master, - ".TB_PREF."payment_terms, ".TB_PREF."debtor_trans WHERE ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY." - AND ".TB_PREF."debtor_trans.payment_terms = ".TB_PREF."payment_terms.terms_indicator AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no AND ".TB_PREF."debtor_trans.debtor_no = $customer_id AND ".TB_PREF."debtor_trans.tran_date <= '$todate'