diff options
-rw-r--r-- | LedgerSMB/AA.pm | 1 |
1 files changed, 1 insertions, 0 deletions
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, |