SF.net SVN: ledger-smb:[6663] trunk/sql/modules/trial_balance.sql

[..hidden..]

Revision: 6663
          http://sourceforge.net/p/ledger-smb/code/6663
Author:   einhverfr
Date:     2014-01-27 07:27:06 +0000 (Mon, 27 Jan 2014)
Log Message:
-----------
Prevending double-counting of trial balance beginning balances

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

Modified: trunk/sql/modules/trial_balance.sql
===================================================================
--- trunk/sql/modules/trial_balance.sql	2014-01-27 05:24:37 UTC (rev 6662)
+++ trunk/sql/modules/trial_balance.sql	2014-01-27 07:27:06 UTC (rev 6663)
@@ -111,7 +111,7 @@
          case when in_date_from is null then 0 else
               CASE WHEN a.category IN ('A', 'E') THEN -1 ELSE 1 END 
               * (coalesce(cp.amount, 0) 
-              + sum(CASE WHEN ac.transdate <= coalesce(in_date_from, 
+              + sum(CASE WHEN ac.transdate < coalesce(in_date_from, 
                                                       t_roll_forward)
                          THEN ac.amount ELSE 0 END)) end, 
               sum(CASE WHEN ac.transdate BETWEEN coalesce(in_date_from, 

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits