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

[..hidden..]

Revision: 3553
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3553&view=rev
Author:   einhverfr
Date:     2011-07-21 19:45:52 +0000 (Thu, 21 Jul 2011)

Log Message:
-----------
Fix for recurring transactions not showing up:

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

Modified: trunk/LedgerSMB/AM.pm
===================================================================
--- trunk/LedgerSMB/AM.pm	2011-07-21 19:36:03 UTC (rev 3552)
+++ trunk/LedgerSMB/AM.pm	2011-07-21 19:45:52 UTC (rev 3553)
@@ -1161,7 +1161,9 @@
                           AS expired
 		     FROM recurring s
 		     JOIN ar a ON (a.id = s.id)
-		     JOIN entity e ON (a.entity_id = e.id)
+                     JOIN entity_credit_account eca 
+                          ON a.entity_credit_account = eca.id
+		     JOIN entity e ON (eca.entity_id = e.id)
 		LEFT JOIN recurringemail se ON (se.id = s.id)
 		LEFT JOIN recurringprint sp ON (sp.id = s.id)
 		LEFT JOIN exchangerate ex 
@@ -1179,7 +1181,9 @@
 		          AS expired
 		     FROM recurring s
 		     JOIN ap a ON (a.id = s.id)
-		     JOIN entity e ON (a.entity_id = e.id)
+                     JOIN entity_credit_account eca 
+                          ON a.entity_credit_account = eca.id
+		     JOIN entity e ON (eca.entity_id = e.id)
 		LEFT JOIN recurringemail se ON (se.id = s.id)
 		LEFT JOIN recurringprint sp ON (sp.id = s.id)
 		LEFT JOIN exchangerate ex ON 


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