From da454db6a221cab55b1059cc7238a1722f424465 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 24 Jun 2011 12:49:11 +0200 Subject: [PATCH] 0000910: Report Aged Customer Analysis Total doesn't match the record totals. --- reporting/rep102.php | 2 -- 1 file changed, 2 deletions(-) diff --git a/reporting/rep102.php b/reporting/rep102.php index 2d00c06..18fab24 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' -- 2.30.2