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

[..hidden..]

Revision: 6439
          http://sourceforge.net/p/ledger-smb/code/6439
Author:   einhverfr
Date:     2014-01-11 07:54:47 +0000 (Sat, 11 Jan 2014)
Log Message:
-----------
correcting threshold on ar/ap transaction reports, see bug 870

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

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-01-11 07:44:12 UTC (rev 6438)
+++ trunk/sql/modules/Report.sql	2014-01-11 07:54:47 UTC (rev 6439)
@@ -546,10 +546,10 @@
                                          AND al.description ilike '%tax'))
             )
             AND ( -- open/closed handling
-              (in_open IS TRUE AND abs(p.due) > 0.001) -- threshold due to 
+              (in_open IS TRUE AND abs(p.due) > 0.005) -- threshold due to 
                                                        -- impossibility to 
                                                        -- collect below -CT
-              OR (in_closed IS TRUE AND p.due = 0)
+              OR (in_closed IS TRUE AND abs(p.due) < 0.005 )
             )
 
 LOOP

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