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

[..hidden..]

Revision: 4465
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4465&view=rev
Author:   einhverfr
Date:     2012-03-15 07:44:52 +0000 (Thu, 15 Mar 2012)
Log Message:
-----------
Adding recon setup to Sample Chart file

Modified Paths:
--------------
    branches/1.3/sql/coa/Sample-chart.sql

Modified: branches/1.3/sql/coa/Sample-chart.sql
===================================================================
--- branches/1.3/sql/coa/Sample-chart.sql	2012-03-15 06:35:28 UTC (rev 4464)
+++ branches/1.3/sql/coa/Sample-chart.sql	2012-03-15 07:44:52 UTC (rev 4465)
@@ -69,6 +69,10 @@
 SELECT account_save(NULL,'5795','Registrations','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'5800','Licenses','E','', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','', NULL, 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 = '2310'),0.1);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.14);

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