SF.net SVN: ledger-smb:[6490] trunk/sql/modules/Report.sql

[..hidden..]

Revision: 6490
          http://sourceforge.net/p/ledger-smb/code/6490
Author:   einhverfr
Date:     2014-01-17 04:38:41 +0000 (Fri, 17 Jan 2014)
Log Message:
-----------
Aging reports now only show accounts with outstanding balances

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

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-01-17 04:30:27 UTC (rev 6489)
+++ trunk/sql/modules/Report.sql	2014-01-17 04:38:41 UTC (rev 6490)
@@ -127,9 +127,10 @@
                        a.invnumber, a.transdate, a.till, a.ordnumber,
                        a.ponumber, a.notes, a.amount, a.sign,
                        a.duedate, a.id, a.curr, a.age
-                HAVING in_business_units is null or in_business_units 
+                HAVING (in_business_units is null or in_business_units 
                        <@ compound_array(string_to_array(bu_tree.path, 
-                                         ',')::int[])
+                                         ',')::int[]))
+                       AND sum(ac.amount::numeric(20,2)) <> 0
 	      ORDER BY entity_id, curr, transdate, invnumber
 	LOOP
 		return next item;

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