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
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
