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

[..hidden..]

Revision: 6491
          http://sourceforge.net/p/ledger-smb/code/6491
Author:   einhverfr
Date:     2014-01-17 05:05:06 +0000 (Fri, 17 Jan 2014)
Log Message:
-----------
trial balance report now only shows accounts with activity from the close prior to the period run

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

Modified: trunk/sql/modules/trial_balance.sql
===================================================================
--- trunk/sql/modules/trial_balance.sql	2014-01-17 04:38:41 UTC (rev 6490)
+++ trunk/sql/modules/trial_balance.sql	2014-01-17 05:05:06 UTC (rev 6491)
@@ -137,6 +137,7 @@
               AND (in_heading IS NULL OR in_heading = a.heading)
      GROUP BY a.id, a.accno, a.description, a.category, a.gifi_accno,
               cp.end_date, cp.account_id, cp.amount, cp.debits, cp.credits
+       HAVING abs(cp.amount) > 0 or count(ac) > 0
      ORDER BY a.accno;
 END;
 $$ language plpgsql;

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