From 05c9e51dcb806570078c0a3d2152c8bbc388719b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 15 Oct 2008 17:49:33 +0000 Subject: Correcting end date handling in trial balance report-- previously end dates entered caused unapproved transactions to be included git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2371 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/RP.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'LedgerSMB') diff --git a/LedgerSMB/RP.pm b/LedgerSMB/RP.pm index 816980de..99dbf1ce 100644 --- a/LedgerSMB/RP.pm +++ b/LedgerSMB/RP.pm @@ -1487,7 +1487,7 @@ sub trial_balance { select id, approved FROM ar) g ON (g.id = ac.trans_id) JOIN chart c ON (c.id = ac.chart_id) - WHERE ac.transdate <= $dateto OR $dateto IS NULL + WHERE (ac.transdate <= $dateto OR $dateto IS NULL) AND ac.approved AND g.approved AND ($safe_project_id IS NULL OR $safe_project_id = ac.project_id) -- cgit v1.2.3