From 2d1701d249eec60066c672bfba14a46b3df8e762 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 26 Jun 2013 21:24:01 +0200 Subject: [PATCH] Fixed mysql 5.0 issue in Print Statements report --- reporting/rep108.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep108.php b/reporting/rep108.php index 894e7f61..b438e641 100644 --- a/reporting/rep108.php +++ b/reporting/rep108.php @@ -44,7 +44,7 @@ function getTransactions($debtorno, $date, $show_also_allocated) AND ABS(".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) > 1e-6"; if (!$show_also_allocated) - $sql .= " AND ABS (ABS(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + + $sql .= " AND ABS(ABS(".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) - alloc) > 1e-6"; $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date"; -- 2.30.2