summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-09-03 16:51:42 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-09-03 16:51:42 +0000
commitccddaac1fc34646f9af8a289e75fe79a32721196 (patch)
tree2ee5de8786171d5c5f8d234adb39ab86107de378
parentf14f96bd6fe3e562b8653dda2fd1c3e9a5702047 (diff)
Correcting issues which occur when insufficient info is imported to include whoever entered ar/ap transactions in ar/ap transaction report.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2308 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--LedgerSMB/AA.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm
index 3a4d8965..9d922bb0 100644
--- a/LedgerSMB/AA.pm
+++ b/LedgerSMB/AA.pm
@@ -833,9 +833,9 @@ sub transactions {
a.ponumber $acc_trans_flds
FROM $table a
JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id)
- JOIN employee e ON (a.person_id = e.entity_id)
+ LEFT JOIN employee e ON (a.person_id = e.entity_id)
LEFT JOIN employee m ON (e.manager_id = m.entity_id)
- JOIN entity ee ON (e.entity_id = ee.id)
+ LEFT JOIN entity ee ON (e.entity_id = ee.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