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

[..hidden..]

Revision: 2135
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2135&view=rev
Author:   einhverfr
Date:     2008-05-12 11:57:17 -0700 (Mon, 12 May 2008)

Log Message:
-----------
Final version of amount_blank_ap_transactions.sql fix

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

Modified: branches/1.2/sql/fixes/amount_blank_ap_transactions.sql
===================================================================
--- branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-12 18:43:21 UTC (rev 2134)
+++ branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-12 18:57:17 UTC (rev 2135)
@@ -16,8 +16,8 @@
 UPDATE ar
 SET netamount = -1 *
 	(select sum(amount) from acc_trans 
-	where trans_id = ap.id 
-		AND ((chart_id IN (select id from chart where link = 'AP')
+	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%')


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