[Phpcompta-dev] r525 - tag/rel660/rapport_avance/include

[phpcompta-dev]

Author: danydb
Date: 2013-07-23 17:46:56 +0200 (Tue, 23 Jul 2013)
New Revision: 525

Modified:
   tag/rel660/rapport_avance/include/class_rapav_declaration.php
Log:
Bug in RAPAV_DD_ACCOUNT, the code for ledger of purchase was wrong

Modified: tag/rel660/rapport_avance/include/class_rapav_declaration.php
===================================================================
--- tag/rel660/rapport_avance/include/class_rapav_declaration.php       
2013-07-10 17:27:28 UTC (rev 524)
+++ tag/rel660/rapport_avance/include/class_rapav_declaration.php       
2013-07-23 15:46:56 UTC (rev 525)
@@ -405,7 +405,7 @@
        {
                static $s_start = "";
                static $s_count = 0;
-            
+
                if ($s_start == "")
                {
                        $s_start = $p_start;
@@ -766,9 +766,9 @@
        {
                if ($this->form->jrn_def_type == 'ACH')
                {
-                       $sql = "select coalesce(sum(qs_vat),0) as amount
-                                               from quant_sold join jrnx using 
(j_id)
-                                               where qs_vat_code=$1
+                       $sql = "select coalesce(sum(qp_vat),0) as amount
+                                               from quant_purchase join jrnx 
using (j_id)
+                                               where qp_vat_code=$1
                                                and (j_date >= 
to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
                                                and j_poste::text like ($4)";
                        $amount = $this->cn->get_value($sql, 
array($this->form->tva_id,



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu