SF.net SVN: ledger-smb: [2144] branches/1.2/sql/fixes/ar_ap_summary_fix_1.2 .14.sql

[..hidden..]

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

Log Message:
-----------
fixed ar_ap_summary_fix again.

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

Modified: branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql
===================================================================
--- branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql	2008-05-14 21:16:26 UTC (rev 2143)
+++ branches/1.2/sql/fixes/ar_ap_summary_fix_1.2.14.sql	2008-05-14 21:38:06 UTC (rev 2144)
@@ -18,7 +18,7 @@
 		where trans_id = ap.id 
 			AND ((chart_id IN 
 				(select id from chart where link = 'AP')
-				     AND amount < 0)
+				     AND amount > 0)
 				OR (chart_id IN 
 					(select id from chart 
 					where link like '%tax%')
@@ -49,7 +49,7 @@
 		where trans_id = ar.id 
 			AND ((chart_id IN (select id from chart 
 				where link = 'AR')
-				     AND amount > 0)
+				     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.