summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-09 23:01:04 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-09 23:01:04 +0000
commit2c97137b280c14b6e4f6ef914de8816c99edd3e8 (patch)
treef9ef45aa629085c6c99bf52ba3283e37ec094d3d
parent7d9e94796fb4e4b76ae739088dc15c858272a90a (diff)
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
-rw-r--r--LedgerSMB/AA.pm1
-rw-r--r--sql/Pg-database.sql2
2 files changed, 3 insertions, 0 deletions
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)
);