SF.net SVN: ledger-smb:[3291] trunk/LedgerSMB/AM.pm

[..hidden..]

Revision: 3291
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3291&view=rev
Author:   ehuelsmann
Date:     2011-06-19 19:09:40 +0000 (Sun, 19 Jun 2011)

Log Message:
-----------
 * LedgerSMB/AM.pm: Resolve 3321964 by listing all accounts marked as 'tax'.

Modified Paths:
--------------
    trunk/LedgerSMB/AM.pm

Modified: trunk/LedgerSMB/AM.pm
===================================================================
--- trunk/LedgerSMB/AM.pm	2011-06-19 18:42:17 UTC (rev 3290)
+++ trunk/LedgerSMB/AM.pm	2011-06-19 19:09:40 UTC (rev 3291)
@@ -1849,8 +1849,11 @@
 		         t.rate * 100 AS rate, t.taxnumber, t.validto,
 			 t.pass, m.taxmodulename
 		    FROM chart c
-		    JOIN tax t ON (c.id = t.chart_id)
-		    JOIN taxmodule m ON (t.taxmodule_id = m.taxmodule_id)
+		    LEFT JOIN
+                     (tax t JOIN taxmodule m 
+                            ON (t.taxmodule_id = m.taxmodule_id))
+                    ON (c.id = t.chart_id)
+                    WHERE c.tax
 		ORDER BY 3, 6|;
 
     my $sth = $dbh->prepare($query);


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