summaryrefslogtreecommitdiff
path: root/LedgerSMB
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-01-18 05:10:19 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-01-18 05:10:19 +0000
commit95a1a1bc48022d7c199bfd63f3f5069686a6d934 (patch)
tree73dd36449b604026081b359bef042e93aab3ae85 /LedgerSMB
parent7fde4d6119cccd548d46adcee7c88b9d1e6a756f (diff)
Correcting join projection issues in AP/Outstanding report
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2050 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB')
-rw-r--r--LedgerSMB/AA.pm4
1 files changed, 3 insertions, 1 deletions
diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm
index 7b9da818..f75187ed 100644
--- a/LedgerSMB/AA.pm
+++ b/LedgerSMB/AA.pm
@@ -722,6 +722,8 @@ sub delete_transaction {
$rc;
}
+# This is going to get a little awkward because it involves delving into the
+# acc_trans table in order to avoid catching unapproved payment vouchers.
sub transactions {
my ( $self, $myconfig, $form ) = @_;
@@ -793,7 +795,7 @@ sub transactions {
d.description AS department,
a.ponumber $acc_trans_flds
FROM $table a
- JOIN entity_credit_account vc USING (entity_id)
+ JOIN entity_credit_account vc ON (a.entity_credit_account = vc.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)