Supplier Transaction Inquiry for GRN did not filter on date. Fixed by @notrinos.

[fa-stable.git] / purchasing / includes / db / supp_trans_db.inc

diff --git a/purchasing/includes/db/supp_trans_db.inc b/purchasing/includes/db/supp_trans_db.inc
index 7790798696ba0ab77b8a5491e1693bf8fd7fad89..8a2f85a9701b4acf2117bbf896abe80360f15dba 100644 (file)
--- 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) {