diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-09-03 16:51:42 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-09-03 16:51:42 +0000 |
| commit | ccddaac1fc34646f9af8a289e75fe79a32721196 (patch) | |
| tree | 2ee5de8786171d5c5f8d234adb39ab86107de378 | |
| parent | f14f96bd6fe3e562b8653dda2fd1c3e9a5702047 (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.pm | 4 |
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 |