SF.net SVN: ledger-smb: [2142] branches/1.2/sql/fixes

[..hidden..]

Revision: 2142
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2142&view=rev
Author:   einhverfr
Date:     2008-05-14 09:19:52 -0700 (Wed, 14 May 2008)

Log Message:
-----------
Renaming fix for 1.2.14

Added Paths:
-----------
    branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql

Removed Paths:
-------------
    branches/1.2/sql/fixes/amount_blank_ap_transactions.sql

Deleted: branches/1.2/sql/fixes/amount_blank_ap_transactions.sql
===================================================================
--- branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-13 00:41:59 UTC (rev 2141)
+++ branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-14 16:19:52 UTC (rev 2142)
@@ -1,32 +0,0 @@
-BEGIN;
-
-UPDATE ap 
-SET netamount = 
-	(select sum(amount) from acc_trans 
-	where trans_id = ap.id 
-		AND ((chart_id IN (select id from chart where link = 'AP')
-			     AND amount > 0)
-			OR (chart_id IN 
-				(select id from chart where link like '%tax%')
-			)
-		)
-	)
-WHERE netamount IS NULL;
-
-update ap set datepaid = NULL where paid = 0;
-
-UPDATE ar
-SET netamount = -1 *
-	(select sum(amount) from acc_trans 
-	where trans_id = ar.id 
-		AND ((chart_id IN (select id from chart where link = 'AR')
-			     AND amount < 0)
-			OR (chart_id IN 
-				(select id from chart where link like '%tax%')
-			)
-		)
-	)
-WHERE netamount IS NULL;
-
-update ar set datepaid = NULL where paid = 0;
-commit;

Copied: branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql (from rev 2141, branches/1.2/sql/fixes/amount_blank_ap_transactions.sql)
===================================================================
--- branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql	                        (rev 0)
+++ branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql	2008-05-14 16:19:52 UTC (rev 2142)
@@ -0,0 +1,32 @@
+BEGIN;
+
+UPDATE ap 
+SET netamount = 
+	(select sum(amount) from acc_trans 
+	where trans_id = ap.id 
+		AND ((chart_id IN (select id from chart where link = 'AP')
+			     AND amount > 0)
+			OR (chart_id IN 
+				(select id from chart where link like '%tax%')
+			)
+		)
+	)
+WHERE netamount IS NULL;
+
+update ap set datepaid = NULL where paid = 0;
+
+UPDATE ar
+SET netamount = -1 *
+	(select sum(amount) from acc_trans 
+	where trans_id = ar.id 
+		AND ((chart_id IN (select id from chart where link = 'AR')
+			     AND amount < 0)
+			OR (chart_id IN 
+				(select id from chart where link like '%tax%')
+			)
+		)
+	)
+WHERE netamount IS NULL;
+
+update ar set datepaid = NULL where paid = 0;
+commit;


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