From df09e8a053742322b3584208153e34cb7beea4ad Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 28 Apr 2011 21:52:26 +0200 Subject: [PATCH] Rerun of Aged Supplier List. --- purchasing/includes/db/suppliers_db.inc | 2 +- reporting/rep202.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/purchasing/includes/db/suppliers_db.inc b/purchasing/includes/db/suppliers_db.inc index 17bd33f2..6630dd2a 100644 --- a/purchasing/includes/db/suppliers_db.inc +++ b/purchasing/includes/db/suppliers_db.inc @@ -109,7 +109,7 @@ function get_supplier_details($supplier_id, $to=null, $all=true) supp.payment_terms = ".TB_PREF."payment_terms.terms_indicator AND supp.supplier_id = $supplier_id "; if (!$all) - $sql .= "AND ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount - trans.alloc) > 0.004 "; + $sql .= "AND ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc > 0.004 "; $sql .= "GROUP BY supp.supp_name, ".TB_PREF."payment_terms.terms, diff --git a/reporting/rep202.php b/reporting/rep202.php index 761186f0..4cf98095 100644 --- a/reporting/rep202.php +++ b/reporting/rep202.php @@ -56,7 +56,7 @@ function get_invoices($supplier_id, $to, $all=true) AND ".TB_PREF."supp_trans.tran_date <= '$todate' AND ABS(".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst + ".TB_PREF."supp_trans.ov_discount) > 0.004 "; if (!$all) - $sql .= "AND ABS(".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst + ".TB_PREF."supp_trans.ov_discount - ".TB_PREF."supp_trans.alloc) > 0.004 "; + $sql .= "AND ABS(".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst + ".TB_PREF."supp_trans.ov_discount) - ".TB_PREF."supp_trans.alloc > 0.004 "; $sql .= "ORDER BY ".TB_PREF."supp_trans.tran_date"; -- 2.30.2