Supplier Allocations: Bank Payments transactions were improperly available for suppli...

diff --git a/purchasing/includes/db/suppalloc_db.inc b/purchasing/includes/db/suppalloc_db.inc
index f54bd3ca27d73e13eae7c8aeecfb41ca3d78d70a..92d4e750db3add241e1d8a59b087bfb933b9a808 100644 (file)
--- a/purchasing/includes/db/suppalloc_db.inc
+++ b/purchasing/includes/db/suppalloc_db.inc
@@ -159,6 +159,7 @@ function get_allocatable_from_supp_sql($supplier_id, $settled)
        return $sql;
 }
 
+
 //-------------------------------------------------------------------------------------------------------------
 
 function get_allocatable_to_supp_transactions($supplier_id, $trans_no=null, $type=null)
@@ -175,7 +176,7 @@ function get_allocatable_to_supp_transactions($supplier_id, $trans_no=null, $typ
        else
        {
                $sql = get_alloc_supp_sql(null, "round(ABS(ov_amount+ov_gst+ov_discount)-alloc,6) > 0
-                       AND trans.type != ".ST_SUPPAYMENT."
+                       AND trans.type NOT IN (".implode(',',array(ST_SUPPAYMENT, ST_BANKPAYMENT)).")
                        AND trans.supplier_id=".db_escape($supplier_id));
        }