Removed voided transactions from Supplier Balances report.

[fa-stable.git] / reporting / rep201.php

diff --git a/reporting/rep201.php b/reporting/rep201.php
index 8131e164e1daa6eb9450a6e437bf982878068987..895c3a5c5ea4361256d5f997165a6eebccc3de09 100644 (file)
--- a/reporting/rep201.php
+++ b/reporting/rep201.php
@@ -70,7 +70,7 @@ function getTransactions($supplier_id, $from, $to)
                                        AND ".TB_PREF."supp_trans.due_date < '$to') AS OverDue
                        FROM ".TB_PREF."supp_trans
                        WHERE ".TB_PREF."supp_trans.tran_date >= '$from' AND ".TB_PREF."supp_trans.tran_date <= '$to' 
-                       AND ".TB_PREF."supp_trans.supplier_id = '$supplier_id'
+                       AND ".TB_PREF."supp_trans.supplier_id = '$supplier_id' AND ".TB_PREF."supp_trans.ov_amount!=0
                                ORDER BY ".TB_PREF."supp_trans.tran_date";
 
     $TransResult = db_query($sql,"No transactions were returned");