Sign bug for customer transactions

[fa-stable.git] / reporting / rep709.php

diff --git a/reporting/rep709.php b/reporting/rep709.php
index 47d079d5c425f822f40193e051bb53c2a54b9719..1321d1ead5112b920303bcb4ac4d0fd3d9c5252c 100644 (file)
--- 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