SF.net SVN: ledger-smb: [2131] trunk

[..hidden..]

Revision: 2131
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2131&view=rev
Author:   einhverfr
Date:     2008-05-09 16:01:04 -0700 (Fri, 09 May 2008)

Log Message:
-----------
Adding ability to force closed transactions (via db only) to prevent them from showing up on the outstanding report.

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm
    trunk/sql/Pg-database.sql

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2008-05-09 17:49:14 UTC (rev 2130)
+++ trunk/LedgerSMB/AA.pm	2008-05-09 23:01:04 UTC (rev 2131)
@@ -813,6 +813,7 @@
 		          (|.$dbh->quote($form->{transdateto}) . qq| IS NULL OR 
 		           |.$dbh->quote($form->{transdateto}) . qq| >= acs.transdate)
 			AND a.approved IS TRUE AND acs.approved IS TRUE
+			AND a.force_closed IS NOT TRUE
 		 GROUP BY a.id, a.invnumber, a.ordnumber, a.transdate, a.duedate, a.netamount,
 		          a.amount, a.terms, a.notes, a.shipvia, a.shippingpoint, vce.name,
 		          vc.meta_number, a.entity_id, a.till, ex.$buysell, d.description,

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2008-05-09 17:49:14 UTC (rev 2130)
+++ trunk/sql/Pg-database.sql	2008-05-09 23:01:04 UTC (rev 2131)
@@ -691,6 +691,7 @@
   reverse bool default false,
   approved bool default true,
   entity_credit_account int references entity_credit_account(id) not null,
+  force_closed bool,
   description text
 );
 
@@ -726,6 +727,7 @@
   reverse bool default false,
   terms int2 DEFAULT 0,
   description text,
+  force_closed bool,
   entity_credit_account int references entity_credit_account(id)
 );
 


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