[Phpcompta-dev] r388 - tag/rel650/tva/sql

[phpcompta-dev]

Author: danydb
Date: 2012-07-01 17:14:00 +0200 (Sun, 01 Jul 2012)
New Revision: 388

Modified:
   tag/rel650/tva/sql/patch2.sql
Log:
correct bug with unexisting tva_id

Modified: tag/rel650/tva/sql/patch2.sql
===================================================================
--- tag/rel650/tva/sql/patch2.sql       2012-07-01 15:12:46 UTC (rev 387)
+++ tag/rel650/tva/sql/patch2.sql       2012-07-01 15:14:00 UTC (rev 388)
@@ -59,7 +59,7 @@
                        select count(*) into n_exist_tva from tva_rate where 
tva_id=a_tva_id[n_size_tva]::numeric;
 
                        if n_exist_tva != 0 then
-                               raise notice 'TVA % exist count = 
%',a_tva_id[n_size_tva],n_exist_tva;
+                               
                                        insert into tva_belge.parameter_chld 
(pcode,tva_id,pcm_val)
                                                values 
(i.pcode,a_tva_id[n_size_tva]::numeric,a_account[n_size_account]::account_type);
                        end if;
@@ -106,7 +106,7 @@
 
        while n_size_tva <> 0 loop
                select count(*) into n_exist_tva from tva_rate where 
tva_id=a_tva_id[n_size_tva]::numeric;
-               raise notice 'TVA % exist count = 
%',a_tva_id[n_size_tva],n_exist_tva;
+
                if n_exist_tva != 0 then
                        insert into tva_belge.parameter_chld (pcode,tva_id)
                                values 
('ASSUJETTI',a_tva_id[n_size_tva]::numeric);



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