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 + 1 file changed, 1 insertion(+) (limited to 'LedgerSMB') 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, -- cgit v1.2.3