diff options
| -rw-r--r-- | LedgerSMB/AA.pm | 1 | ||||
| -rw-r--r-- | sql/Pg-database.sql | 2 |
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) ); |