From 087153ed5b9ac7867d2d5018473384102e687f27 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Wed, 14 Oct 2009 14:36:27 +0000 Subject: [PATCH] [0000172] Difference between Customer Balances and Print Statements --- CHANGELOG.txt | 4 ++++ reporting/rep108.php | 3 ++- 2 files changed, 6 insertions(+), 1 deletion(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 3f0dc9e1..b0dfaaff 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,10 @@ Legend: ! -> Note $ -> Affected files +14-Oct-2009 Joe Hunt +# [0000172] Difference between Customer Balances and Print Statements +$ /reporting/rep108.pp + 13-Oct-2009 Janusz Dobrowolski # Fixed default page access. $ /sales/inquiry/sales_orders_view.php diff --git a/reporting/rep108.php b/reporting/rep108.php index a85073a2..843e747e 100644 --- a/reporting/rep108.php +++ b/reporting/rep108.php @@ -32,7 +32,8 @@ print_statements(); function getTransactions($debtorno, $date) { $sql = "SELECT ".TB_PREF."debtor_trans.*, - (".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.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) AS TotalAmount, ".TB_PREF."debtor_trans.alloc AS Allocated, ((".TB_PREF."debtor_trans.type = ".ST_SALESINVOICE.") AND ".TB_PREF."debtor_trans.due_date < '$date') AS OverDue -- 2.30.2