From 6166e84787eef3317656b10cbdcbb41f980084f9 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 21 Feb 2008 06:20:05 +0000 Subject: Corrections for vouchers and AP Outstanding Report git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2075 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 a8c712b8..3d02b55f 100644 --- a/LedgerSMB/AA.pm +++ b/LedgerSMB/AA.pm @@ -812,6 +812,7 @@ sub transactions { WHERE c.link = '$form->{ARAP}' AND (|.$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 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