diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-06 17:12:46 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-06 17:12:46 +0000 |
| commit | 87ca70bacd544f1b027cb640e9caed28323f5c8b (patch) | |
| tree | af71436d1f5a3335836a82243069644b139dbfd3 | |
| parent | 3c1095e2427a297630f57cd9d6a7c334a634cb3d (diff) | |
Correcting join problem when pulling up existing AP Transactions
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2233 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | LedgerSMB/Form.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm index 9883839c..3d43b8a6 100644 --- a/LedgerSMB/Form.pm +++ b/LedgerSMB/Form.pm @@ -2248,7 +2248,8 @@ sub create_links { c.language_code, a.ponumber, a.reverse, a.approved FROM $arap a - JOIN entity_credit_account c USING (entity_id) + JOIN entity_credit_account c + ON (a.entity_credit_account = c.id) JOIN entity ce ON (ce.id = c.entity_id) LEFT JOIN employee er ON (er.entity_id = a.person_id) LEFT JOIN entity e ON (er.entity_id = e.id) |