From 8556a5ade88cada472943b85cb6e3cb1c93506d6 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 7 Mar 2008 19:10:03 +0000 Subject: [PATCH] Fixed bug selecting allocated transactions as overdue. --- sales/inquiry/customer_inquiry.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index ee8d4b3d..52119435 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -94,7 +94,11 @@ function get_transactions() (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) AS TotalAmount, ".TB_PREF."debtor_trans.alloc AS Allocated, ((".TB_PREF."debtor_trans.type = 10) - AND ".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue + AND (".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "') + AND ((".TB_PREF."debtor_trans.ov_amount + " + .TB_PREF."debtor_trans.ov_gst + " + .TB_PREF."debtor_trans.ov_freight )>".TB_PREF."debtor_trans.alloc + )) AS OverDue FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master WHERE ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no AND ".TB_PREF."debtor_trans.tran_date >= '$date_after' -- 2.30.2