From 86426eeedebcb44564ffa70455a8a8eb9856e499 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 17 Jun 2009 14:07:29 +0000 Subject: [PATCH] Voided documents should not be displayed. --- purchasing/inquiry/supplier_inquiry.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/purchasing/inquiry/supplier_inquiry.php b/purchasing/inquiry/supplier_inquiry.php index cc94acd..5fc3e0c 100644 --- a/purchasing/inquiry/supplier_inquiry.php +++ b/purchasing/inquiry/supplier_inquiry.php @@ -175,7 +175,8 @@ function check_overdue($row) FROM ".TB_PREF."supp_trans as trans, ".TB_PREF."suppliers as supplier WHERE supplier.supplier_id = trans.supplier_id AND trans.tran_date >= '$date_after' - AND trans.tran_date <= '$date_to'"; + AND trans.tran_date <= '$date_to' + AND trans.ov_amount != 0"; // exclude voided transactions if ($_POST['supplier_id'] != reserved_words::get_all()) $sql .= " AND trans.supplier_id = '" . $_POST['supplier_id'] . "'"; if (isset($_POST['filterType']) && $_POST['filterType'] != reserved_words::get_all()) -- 2.30.2