Huge sales module changes toward delivery and invoicing separation. Includes some...

[fa-stable.git] / sales / inquiry / customer_allocation_inquiry.php

diff --git a/sales/inquiry/customer_allocation_inquiry.php b/sales/inquiry/customer_allocation_inquiry.php
index 07aad1e3d7b04eb02bf8fe13d9b83f12bf93a9a1..f8cc1afc04de81fa44aa78697e573d765b5fefd8 100644 (file)
--- a/sales/inquiry/customer_allocation_inquiry.php
+++ b/sales/inquiry/customer_allocation_inquiry.php
@@ -90,8 +90,12 @@ function get_transactions()
                $sql .= " AND ".TB_PREF."debtor_trans.due_date < '$today'
                                AND (round(abs(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) - ".TB_PREF."debtor_trans.alloc,6) > 0) ";
        }
+       }else
+       {
+           $sql .= " AND ".TB_PREF."debtor_trans.type != 13 ";
        }
 
+
        if (!check_value('showSettled')) 
        {
                $sql .= " AND (round(abs(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) - ".TB_PREF."debtor_trans.alloc,6) != 0) ";