Supplier Transaction Inquiry for GRN did not filter on date. Fixed by @notrinos.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Wed, 2 Jan 2019 08:12:17 +0000 (09:12 +0100)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Wed, 2 Jan 2019 08:12:17 +0000 (09:12 +0100)
purchasing/includes/db/supp_trans_db.inc

index 7790798696ba0ab77b8a5491e1693bf8fd7fad89..8a2f85a9701b4acf2117bbf896abe80360f15dba 100644 (file)
@@ -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) {