From 2c97137b280c14b6e4f6ef914de8816c99edd3e8 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 9 May 2008 23:01:04 +0000 Subject: Adding ability to force closed transactions (via db only) to prevent them from showing up on the outstanding report. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2131 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/AA.pm | 1 + sql/Pg-database.sql | 2 ++ 2 files changed, 3 insertions(+) diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm index 80d67a08..e9e2a978 100644 --- a/LedgerSMB/AA.pm +++ b/LedgerSMB/AA.pm @@ -813,6 +813,7 @@ sub transactions { (|.$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, diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 757567ed..b93f47f4 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -691,6 +691,7 @@ CREATE TABLE ar ( 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 @@ CREATE TABLE ap ( reverse bool default false, terms int2 DEFAULT 0, description text, + force_closed bool, entity_credit_account int references entity_credit_account(id) ); -- cgit v1.2.3