SF.net SVN: ledger-smb:[2308] trunk/LedgerSMB/AA.pm

[..hidden..]

Revision: 2308
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2308&view=rev
Author:   einhverfr
Date:     2008-09-03 16:51:42 +0000 (Wed, 03 Sep 2008)

Log Message:
-----------
Correcting issues which occur when insufficient info is imported to include whoever entered ar/ap transactions in ar/ap transaction report.

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

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2008-09-02 19:59:04 UTC (rev 2307)
+++ trunk/LedgerSMB/AA.pm	2008-09-03 16:51:42 UTC (rev 2308)
@@ -833,9 +833,9 @@
 		          a.ponumber $acc_trans_flds
 		     FROM $table a
 		     JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id)
-		     JOIN employee e ON (a.person_id = e.entity_id)
+		LEFT JOIN employee e ON (a.person_id = e.entity_id)
 		LEFT JOIN employee m ON (e.manager_id = m.entity_id)
-		     JOIN entity ee ON (e.entity_id = ee.id)
+		LEFT JOIN entity ee ON (e.entity_id = ee.id)
                 LEFT JOIN entity me ON (m.entity_id = me.id)
 		     JOIN entity vce ON (vc.entity_id = vce.id)
 		LEFT JOIN exchangerate ex ON (ex.curr = a.curr


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