From 6725b79409892d6f03be0d6e8888a42b9c730d0c Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 18 Feb 2013 10:07:30 +0100 Subject: [PATCH] Removed voided transactions from Supplier Balances report. --- reporting/rep201.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep201.php b/reporting/rep201.php index 8131e164..895c3a5c 100644 --- 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"); -- 2.30.2