[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[4477] branches/1.3

Subject: SF.net SVN: ledger-smb:[4477] branches/1.3
From: ..hidden..
Date: Thu, 15 Mar 2012 10:58:03 +0000
Revision: 4477
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4477&view=rev
Author:   einhverfr
Date:     2012-03-15 10:58:03 +0000 (Thu, 15 Mar 2012)
Log Message:
-----------
Correcting bug 3505102, a few locales still missing recon data

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/coa/cz/chart/General.sql
    branches/1.3/sql/coa/fr/chart/General.sql
    branches/1.3/sql/coa/hu/chart/Complete.sql
    branches/1.3/sql/coa/hu/chart/Minimal.sql
    branches/1.3/sql/coa/hu/chart/Old-general.sql
    branches/1.3/sql/coa/lv/chart/General.sql
    branches/1.3/sql/coa/pl/chart/General.sql

Property Changed:
----------------
    branches/1.3/sql/coa/

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/Changelog	2012-03-15 10:58:03 UTC (rev 4477)
@@ -10,6 +10,7 @@
 * Added recon data to Norwegian chart of accounts (h/t H. Sorli) (Chris T)
 * Fixed some menu items disappearing after upgrade (Chris T, bug 3504934)
 * Added default to country for initial setup (Chris T, bug 3496967)
+* Added recon data to COA files for a few extra locales (Chris T bug 3505102)
 
 Andres B is Andres Basile
 


Property changes on: branches/1.3/sql/coa
___________________________________________________________________
Added: svn:mergeinfo
   + /trunk/sql/coa:3711-3712,4476

Modified: branches/1.3/sql/coa/cz/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/cz/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/cz/chart/General.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -313,6 +313,10 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10603, '70100', 'PoÄÃteÄnÃ ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10605, '70200', 'KoneÄnÃ ÃÄet rozvaÅnÃ', 'A', 'A', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10607, '71000', 'ÃÄet ziskÅ a ztrÃt', 'A', 'A', '', '', false);
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34311'),0.05);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.19);

Modified: branches/1.3/sql/coa/fr/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/fr/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/fr/chart/General.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -939,6 +939,10 @@
 --
 SELECT account_save(NULL,'999000','Foreign Exchange Gain','I','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'999010','Foreign Exchange Loss','E','', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 -- insert taxes
 --

Modified: branches/1.3/sql/coa/hu/chart/Complete.sql
===================================================================
--- branches/1.3/sql/coa/hu/chart/Complete.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/hu/chart/Complete.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -413,6 +413,10 @@
 SELECT account_save(NULL,'4673','FizetendÅ ÃFA 0%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'4674','FizetendÅ ÃFA adÃmentes','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
+
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.20','VIS');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4662'),'0.05','VIS');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4663'),'0','VIS');

Modified: branches/1.3/sql/coa/hu/chart/Minimal.sql
===================================================================
--- branches/1.3/sql/coa/hu/chart/Minimal.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/hu/chart/Minimal.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -36,6 +36,10 @@
 SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.20','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: branches/1.3/sql/coa/hu/chart/Old-general.sql
===================================================================
--- branches/1.3/sql/coa/hu/chart/Old-general.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/hu/chart/Old-general.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -36,6 +36,10 @@
 SELECT account_save(NULL,'9110','BelfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9111','KÃlfÃldi ÃrbevÃtel','I','911', NULL, false, false, string_to_array('AR_amount:IC_sale:IC_income', ':'));
 SELECT account_save(NULL,'9700','ÃrfolyamnyeresÃg','I','970', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4660'),'0.25','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno='4661'),'0.15','');

Modified: branches/1.3/sql/coa/lv/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/lv/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/lv/chart/General.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -246,6 +246,10 @@
 SELECT account_save(NULL,'1330','LÃdzdalÃbas saistÃto uzÃÃmumu kapitÃlÃ','','A', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2354','PVN samaksÃts 18%','','E', NULL, false, false, string_to_array('AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2352','PVN ieÃemtais 18%','','L', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2352'),'0.18','');
 INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2354'),'0.18','');

Modified: branches/1.3/sql/coa/pl/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/pl/chart/General.sql	2012-03-15 10:49:17 UTC (rev 4476)
+++ branches/1.3/sql/coa/pl/chart/General.sql	2012-03-15 10:58:03 UTC (rev 4477)
@@ -324,6 +324,10 @@
 SELECT account_save(NULL,'893000000','Odpisy z zysku netto w ciÂgu roku obrotowego','Q','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'893010000','Podatek dochodowy','Q','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'893020000','Inne obowiÂzkowe obciÂÂenia wyniku finansowego','Q','', NULL, false, false, string_to_array('', ':'));
+
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223020100'),0.22);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '223020200'),0.07);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb:[4476] trunk/sql/coa
Next by Date: SF.net SVN: ledger-smb:[4478] trunk/LedgerSMB/Scripts/payment.pm
Previous by thread: SF.net SVN: ledger-smb:[4476] trunk/sql/coa
Next by thread: SF.net SVN: ledger-smb:[4478] trunk/LedgerSMB/Scripts/payment.pm
Index(es):
- Date
- Thread