[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 5820
          http://sourceforge.net/p/ledger-smb/code/5820
Author:   einhverfr
Date:     2013-05-18 07:09:40 +0000 (Sat, 18 May 2013)
Log Message:
-----------
Correcting beginning balance calculation on gl report.

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

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2013-05-18 07:06:53 UTC (rev 5819)
+++ branches/1.3/Changelog	2013-05-18 07:09:40 UTC (rev 5820)
@@ -10,6 +10,7 @@
 * Fixed grants to menus (which can cause problems for submenus (Chris T, 820)
 * Fixed tax boxes cannot be all unset (Chris T, 818)
 * Project, serial number, and notes now appear initially (Chris T, 824)
+* Fixed double-counting first date's balance on gl report (Chris T)
 
 Changelog for 1.3.32
 * Fixed em-dash handling for pdfs (Chris T)

Modified: branches/1.3/LedgerSMB/GL.pm
===================================================================
--- branches/1.3/LedgerSMB/GL.pm	2013-05-18 07:06:53 UTC (rev 5819)
+++ branches/1.3/LedgerSMB/GL.pm	2013-05-18 07:09:40 UTC (rev 5820)
@@ -421,7 +421,7 @@
 
         if ( $form->{datefrom} ) {
             $query = qq|
-			SELECT account__obtain_balance(?, id) from chart
+			SELECT account__obtain_balance(?::date - 1, id) from chart
 			WHERE accno = ? |;
             my $sth = $dbh->prepare($query);
             $sth->execute($form->{datefrom}, $form->{chart_accno});

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