SF.net SVN: ledger-smb:[4462] branches/1.3/sql/coa/ar/chart

[..hidden..]

Revision: 4462
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4462&view=rev
Author:   einhverfr
Date:     2012-03-15 04:54:43 +0000 (Thu, 15 Mar 2012)
Log Message:
-----------
Setting up reconciliation on Argentine charts

Modified Paths:
--------------
    branches/1.3/sql/coa/ar/chart/General.sql
    branches/1.3/sql/coa/ar/chart/Personal.sql

Modified: branches/1.3/sql/coa/ar/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/ar/chart/General.sql	2012-03-15 04:50:49 UTC (rev 4461)
+++ branches/1.3/sql/coa/ar/chart/General.sql	2012-03-15 04:54:43 UTC (rev 4462)
@@ -142,6 +142,9 @@
 -- IVA Favor
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '1.1.5.01'), 0.21);
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 -- Sistema
 -- Predeterminados
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0.03'));

Modified: branches/1.3/sql/coa/ar/chart/Personal.sql
===================================================================
--- branches/1.3/sql/coa/ar/chart/Personal.sql	2012-03-15 04:50:49 UTC (rev 4461)
+++ branches/1.3/sql/coa/ar/chart/Personal.sql	2012-03-15 04:54:43 UTC (rev 4462)
@@ -100,6 +100,9 @@
 -- IVA Favor
 INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '1.4.10'), 0.21);
 
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE id IN (select account_id FROM account_link
+                           WHERE description = 'AP_paid');
 -- Sistema
 -- Predeterminados
 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0.20'));

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.