SF.net SVN: ledger-smb:[6868] trunk/sql/modules/Report.sql

[..hidden..]

Revision: 6868
          http://sourceforge.net/p/ledger-smb/code/6868
Author:   einhverfr
Date:     2014-02-17 10:37:26 +0000 (Mon, 17 Feb 2014)
Log Message:
-----------
Fixing 1068, invoices don't show up unless associated with salesperson

Modified Paths:
--------------
    trunk/sql/modules/Report.sql

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-02-17 10:08:27 UTC (rev 6867)
+++ trunk/sql/modules/Report.sql	2014-02-17 10:37:26 UTC (rev 6868)
@@ -408,7 +408,9 @@
       GROUP BY trans_id) p ON p.trans_id = a.id
   JOIN entity_credit_account eca ON a.entity_credit_account = eca.id
   JOIN entity eeca ON eca.entity_id = eeca.id
+  LEFT
   JOIN entity_employee ON entity_employee.entity_id = a.person_id
+  LEFT
   JOIN entity ee ON entity_employee.entity_id = ee.id
   LEFT
   JOIN entity me ON entity_employee.manager_id = me.id
@@ -504,7 +506,9 @@
          WHERE l.description IN ('AR', 'AP')
       GROUP BY ac.trans_id
        ) p ON p.trans_id = a.id
+  LEFT
   JOIN entity_employee ee ON ee.entity_id = a.person_id
+  LEFT
   JOIN entity eee ON eee.id = ee.entity_id
   JOIN entity_credit_account eca ON a.entity_credit_account = eca.id
   JOIN entity eeca ON eca.entity_id = eeca.id

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


------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits