From 2372b4a26fcf802fae7a4946eafc0de0de4bee6d Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 10 May 2010 07:18:52 +0000 Subject: [PATCH] Changed so Print Statements don't list voided items. --- CHANGELOG.txt | 4 ++++ reporting/rep108.php | 2 ++ 2 files changed, 6 insertions(+) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 76576493..8cb8f903 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,10 @@ Legend: ! -> Note $ -> Affected files +10-May-2010 Joe Hunt/Alvin +! Changed so Print Statements don't list voided items. +$ /reporting/rep108.php + 04-May-2010 Janusz Dobrowolski/Robert Laussegger # Fixed amibiguites and typos in report titles. $ /reporting/includes/doctext.inc diff --git a/reporting/rep108.php b/reporting/rep108.php index b896b73b..f4a8aa32 100644 --- a/reporting/rep108.php +++ b/reporting/rep108.php @@ -40,6 +40,8 @@ function getTransactions($debtorno, $date) FROM ".TB_PREF."debtor_trans WHERE ".TB_PREF."debtor_trans.tran_date <= '$date' AND ".TB_PREF."debtor_trans.debtor_no = ".db_escape($debtorno)." AND ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY." + AND (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + + ".TB_PREF."debtor_trans.ov_freight_tax + ".TB_PREF."debtor_trans.ov_discount) != 0 ORDER BY ".TB_PREF."debtor_trans.tran_date"; return db_query($sql,"No transactions were returned"); -- 2.30.2