summaryrefslogtreecommitdiff
path: root/LedgerSMB/AA.pm
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-09-01 22:49:54 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-09-01 22:49:54 +0000
commitb1d3c56e3824b123e09bf807ee1cd9a71ca43efc (patch)
treeb08d91c62c87b60085d55c2c3b3557ad654765b9 /LedgerSMB/AA.pm
parent0ca18bdebd500c752b7ae1dcc8f54c65fd2c25af (diff)
Fixing bind errors when transdate is omitted in Form::all_vc and also ensuring that invoices show up in transaction report.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1493 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB/AA.pm')
-rw-r--r--LedgerSMB/AA.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm
index dfcb0cc4..449819d5 100644
--- a/LedgerSMB/AA.pm
+++ b/LedgerSMB/AA.pm
@@ -784,11 +784,11 @@ sub transactions {
d.description AS department,
a.ponumber $acc_trans_flds
FROM $table a
- JOIN $form->{vc} vc USING (entity_id)
+ JOIN entity_credit_account vc USING (entity_id)
LEFT JOIN employee e ON (a.person_id = e.entity_id)
LEFT JOIN employee m ON (e.managerid = m.entity_id)
JOIN entity ee ON (e.entity_id = ee.id)
- JOIN entity me ON (m.entity_id = me.id)
+ LEFT JOIN entity me ON (m.entity_id = me.id)
JOIN entity vce ON (vc.entity_id = vce.id)
LEFT JOIN exchangerate ex ON (ex.curr = a.curr
AND ex.transdate = a.transdate)