From d30707a90159ed1f421ad064720306c4fb34bba0 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Wed, 2 Jan 2019 09:12:17 +0100 Subject: [PATCH] Supplier Transaction Inquiry for GRN did not filter on date. Fixed by @notrinos. --- purchasing/includes/db/supp_trans_db.inc | 2 ++ 1 file changed, 2 insertions(+) diff --git a/purchasing/includes/db/supp_trans_db.inc b/purchasing/includes/db/supp_trans_db.inc index 77907986..8a2f85a9 100644 --- a/purchasing/includes/db/supp_trans_db.inc +++ b/purchasing/includes/db/supp_trans_db.inc @@ -258,6 +258,8 @@ function get_sql_for_supplier_inquiry($filter, $after_date, $to_date, $supplier_ else { $sql .= " AND trans.tran_date >= '$date_after' AND trans.tran_date <= '$date_to'"; + $sql2 .= " AND trans.delivery_date >= '$date_after' + AND trans.delivery_date <= '$date_to'"; } if ($supplier_id != ALL_TEXT) { -- 2.30.2