SF.net SVN: ledger-smb:[5591] branches/1.3

[..hidden..]

Revision: 5591
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5591&view=rev
Author:   einhverfr
Date:     2013-01-16 08:36:48 +0000 (Wed, 16 Jan 2013)
Log Message:
-----------
Net 0 transactions showing up under transaction search now, fix for 1.3 entirely independent of fix for 1.4

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/LedgerSMB/AA.pm

Property Changed:
----------------
    branches/1.3/
    branches/1.3/Changelog


Property changes on: branches/1.3
___________________________________________________________________
Modified: svn:mergeinfo
   - /trunk:3711-3712,5424,5446-5448,5451,5457,5459,5461,5466,5473,5475,5482-5483,5485,5487,5489,5495-5496,5515,5519,5524,5526,5528-5529,5533,5544-5546,5548-5549,5554-5555,5563,5565,5569,5576,5579
   + /trunk:3711-3712,5424,5446-5448,5451,5457,5459,5461,5466,5473,5475,5482-5483,5485,5487,5489,5495-5496,5515,5519,5524,5526,5528-5529,5533,5544-5546,5548-5549,5554-5555,5563,5565,5569,5576,5579,5590

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2013-01-16 08:32:47 UTC (rev 5590)
+++ branches/1.3/Changelog	2013-01-16 08:36:48 UTC (rev 5591)
@@ -15,6 +15,7 @@
 * Fixed inverted tax numbers in vendor taxable sales report (Chris T, 3600002)
 * Fixed cash/receipt and payment screen calculating to pay wrong (Chris T,
 3599995)
+* Fixed net-0 transactions not showing up on search (Chris T, 3600700)
 
 Changelog for 1.3.28
 * Added db list to setup.pl when no db is entered and credentials allow login


Property changes on: branches/1.3/Changelog
___________________________________________________________________
Modified: svn:mergeinfo
   - /trunk/Changelog:3711-3712,5424,5446-5448,5451,5457,5459,5461,5466,5473,5475,5482-5483,5485,5487,5489,5495-5496,5513,5515,5519,5524,5529,5548,5563,5565,5578-5579,5581,5583,5587
   + /trunk/Changelog:3711-3712,5424,5446-5448,5451,5457,5459,5461,5466,5473,5475,5482-5483,5485,5487,5489,5495-5496,5513,5515,5519,5524,5529,5548,5563,5565,5578-5579,5581,5583,5587,5590

Modified: branches/1.3/LedgerSMB/AA.pm
===================================================================
--- branches/1.3/LedgerSMB/AA.pm	2013-01-16 08:32:47 UTC (rev 5590)
+++ branches/1.3/LedgerSMB/AA.pm	2013-01-16 08:36:48 UTC (rev 5591)
@@ -953,7 +953,7 @@
 		          a.ponumber $acc_trans_flds
 		     FROM $table a
 		     JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id)
-		     JOIN acc_trans acs ON (acs.trans_id = a.id)
+		LEFT JOIN acc_trans acs ON (acs.trans_id = a.id)
 		     JOIN entity vce ON (vc.entity_id = vce.id)
 		     JOIN chart c ON (acs.chart_id = c.id
                                       AND charttype='A')
@@ -991,7 +991,7 @@
 		     JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id)
                      JOIN acc_trans ac ON (a.id = ac.trans_id)
                      JOIN chart c ON (c.id = ac.chart_id)
-                     JOIN (SELECT acc_trans.trans_id,
+                LEFT JOIN (SELECT acc_trans.trans_id,
                                 sum(CASE WHEN '$table' = 'ap' THEN amount
                                          WHEN '$table' = 'ar'
                                          THEN amount * -1

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