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

[..hidden..]

Revision: 6855
          http://sourceforge.net/p/ledger-smb/code/6855
Author:   einhverfr
Date:     2014-02-13 14:23:44 +0000 (Thu, 13 Feb 2014)
Log Message:
-----------
fixing report so null ar/ap.force_closed values are treated as false.

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

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-02-13 11:35:50 UTC (rev 6854)
+++ trunk/sql/modules/Report.sql	2014-02-13 14:23:44 UTC (rev 6855)
@@ -120,7 +120,7 @@
 	     LEFT JOIN country ON (country.id = l.country_id)
                  WHERE (e.id = in_entity_id OR in_entity_id IS NULL)
                        AND (in_accno IS NULL or acc.accno = in_accno)
-                       AND NOT a.force_closed
+                       AND a.force_closed IS NOT TRUE
               GROUP BY c.entity_id, c.meta_number, e.name,
                        l.line_one, l.line_two, l.line_three,
                        l.city, l.state, l.mail_code, country.name,
@@ -427,7 +427,7 @@
        AND (in_from_date IS NULL OR a.transdate >= in_from_date)
        AND (in_to_date IS NULL OR a.transdate <= in_to_date)
        AND p.due::numeric(100,2) <> 0 
-       AND NOT a.force_closed
+       AND a.force_closed IS NOT TRUE
        AND (in_partnumber IS NULL 
           OR EXISTS(SELECT 1 FROM invoice inv 
                       JOIN parts ON inv.parts_id = parts.id

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


------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits