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

[..hidden..]

Revision: 6403
          http://sourceforge.net/p/ledger-smb/code/6403
Author:   einhverfr
Date:     2014-01-06 08:43:32 +0000 (Mon, 06 Jan 2014)
Log Message:
-----------
Fixing open/closed handling in transactions report

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

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-01-06 08:11:36 UTC (rev 6402)
+++ trunk/sql/modules/Report.sql	2014-01-06 08:43:32 UTC (rev 6403)
@@ -546,8 +546,10 @@
                                          AND al.description ilike '%tax'))
             )
             AND ( -- open/closed handling
-              (in_open IS TRUE AND p.due <> 0) 
-              OR (in_closed IS TRUE AND p.due = 0 or p.due is null)
+              (in_open IS TRUE AND abs(p.due) > 0.001) -- threshold due to 
+                                                       -- impossibility to 
+                                                       -- collect below -CT
+              OR (in_closed IS TRUE AND p.due = 0)
             )
 
 LOOP

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


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits