SF.net SVN: ledger-smb:[2233] trunk/LedgerSMB/Form.pm

[..hidden..]

Revision: 2233
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2233&view=rev
Author:   einhverfr
Date:     2008-08-06 17:12:46 +0000 (Wed, 06 Aug 2008)

Log Message:
-----------
Correcting join problem when pulling up existing AP Transactions

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

Modified: trunk/LedgerSMB/Form.pm
===================================================================
--- trunk/LedgerSMB/Form.pm	2008-08-05 20:55:59 UTC (rev 2232)
+++ trunk/LedgerSMB/Form.pm	2008-08-06 17:12:46 UTC (rev 2233)
@@ -2248,7 +2248,8 @@
 				c.language_code, a.ponumber, a.reverse,
                                 a.approved
 			FROM $arap a
-			JOIN entity_credit_account c USING (entity_id)
+			JOIN entity_credit_account c 
+				ON (a.entity_credit_account = c.id)
 			JOIN entity ce ON (ce.id = c.entity_id)
 			LEFT JOIN employee er ON (er.entity_id = a.person_id)
 			LEFT JOIN entity e ON (er.entity_id = e.id)


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