SF.net SVN: ledger-smb:[3650] trunk/LedgerSMB/RP.pm

[..hidden..]

Revision: 3650
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3650&view=rev
Author:   einhverfr
Date:     2011-08-09 23:12:43 +0000 (Tue, 09 Aug 2011)

Log Message:
-----------
Correcting bug 3386937

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

Modified: trunk/LedgerSMB/RP.pm
===================================================================
--- trunk/LedgerSMB/RP.pm	2011-08-09 22:51:44 UTC (rev 3649)
+++ trunk/LedgerSMB/RP.pm	2011-08-09 23:12:43 UTC (rev 3650)
@@ -1462,7 +1462,7 @@
         if ($year_end ne 'none'){
              if ($year_end eq 'last'){
                   $yearend_filter = "AND (ac.transdate < coalesce($datefrom, ac.transdate)  OR 
-			ac.trans_id <> (select max(trans_id) FROM yearend WHERE transdate <= coalesce($dateto, 'infinity'::timestamp)))";
+			ac.trans_id <> (select coalesce(max(trans_id), -1000) FROM yearend WHERE transdate <= coalesce($dateto, 'infinity'::timestamp)))";
              } elsif ($year_end eq 'all'){
                   $yearend_filter = "AND (y.trans_id is null or ac.transdate < coalesce($datefrom, ac.transdate))";
              } else {


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