From 6885f276e8e8bcedf735f8f4e46412044d73bf36 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 17 Mar 2008 09:19:00 +0000 Subject: [PATCH] Sign bug for customer transactions --- reporting/rep709.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep709.php b/reporting/rep709.php index 47d079d5..1321d1ea 100644 --- a/reporting/rep709.php +++ b/reporting/rep709.php @@ -92,7 +92,7 @@ function getCustInvTax($taxtype, $from, $to) $fromdate = date2sql($from); $todate = date2sql($to); - $sql = "SELECT SUM(unit_price * -quantity*".TB_PREF."debtor_trans.rate), SUM(amount*".TB_PREF."debtor_trans.rate) + $sql = "SELECT SUM(unit_price * quantity*".TB_PREF."debtor_trans.rate), SUM(amount*".TB_PREF."debtor_trans.rate) FROM ".TB_PREF."debtor_trans_details, ".TB_PREF."debtor_trans_tax_details, ".TB_PREF."debtor_trans WHERE ".TB_PREF."debtor_trans_details.debtor_trans_type>=10 AND ".TB_PREF."debtor_trans_details.debtor_trans_type<=11 -- 2.30.2