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

[..hidden..]

Revision: 6834
          http://sourceforge.net/p/ledger-smb/code/6834
Author:   einhverfr
Date:     2014-02-10 14:17:57 +0000 (Mon, 10 Feb 2014)
Log Message:
-----------
trial balance starting point fixes, for 1066

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

Modified: trunk/sql/modules/trial_balance.sql
===================================================================
--- trunk/sql/modules/trial_balance.sql	2014-02-10 14:04:33 UTC (rev 6833)
+++ trunk/sql/modules/trial_balance.sql	2014-02-10 14:17:57 UTC (rev 6834)
@@ -47,12 +47,14 @@
                            WHERE y.transdate < coalesce(in_date_to, gl.transdate)
                          );
     ELSIF in_date_from IS NULL THEN
-       SELECT min(transdate)  INTO t_roll_forward
+       SELECT min(transdate) - 1 INTO t_roll_forward
          FROM (select min(transdate) as transdate from ar
                 union ALL
                select min(transdate) from ap
                 union all
-               select min(transdate) from gl) gl;
+               select min(transdate) from gl
+                union all
+               select min(transdate) from acc_trans) gl;
                            
     ELSE
       SELECT max(end_date) INTO t_roll_forward

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits