summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-06 17:12:46 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-06 17:12:46 +0000
commit87ca70bacd544f1b027cb640e9caed28323f5c8b (patch)
treeaf71436d1f5a3335836a82243069644b139dbfd3
parent3c1095e2427a297630f57cd9d6a7c334a634cb3d (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.pm3
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)