SF.net SVN: ledger-smb:[2956] addons/1.3/enhanced_tb/trunk/sql/modules/ trial_balance.sql

[..hidden..]

Revision: 2956
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2956&view=rev
Author:   einhverfr
Date:     2010-03-10 05:37:17 +0000 (Wed, 10 Mar 2010)

Log Message:
-----------
Minor tweak to allow headings to be handled properly in enhanced trial balance

Modified Paths:
--------------
    addons/1.3/enhanced_tb/trunk/sql/modules/trial_balance.sql

Modified: addons/1.3/enhanced_tb/trunk/sql/modules/trial_balance.sql
===================================================================
--- addons/1.3/enhanced_tb/trunk/sql/modules/trial_balance.sql	2010-03-10 05:33:00 UTC (rev 2955)
+++ addons/1.3/enhanced_tb/trunk/sql/modules/trial_balance.sql	2010-03-10 05:37:17 UTC (rev 2956)
@@ -65,8 +65,8 @@
                 WHERE ac.approved is true and gl.approved is true and
                       (in_date_to is null or ac.transdate <= in_date_to) and
                       (cp.end_date is null or ac.transdate > cp.end_date) and
-		      (in_heading is null or a.heading = in_heading or
-                       a.id = any(in_accounts)) and
+		      (in_heading is null or a.heading = in_heading)
+                       (in_accounts is null or a.id = any(in_accounts) and
                        (in_ignore_yearend = 'none' OR y.id is NULL 
                        or y.id = include_trans)
 		GROUP BY a.id, a.description, a.accno, a.contra, a.category,


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