diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-11 04:54:33 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-11 04:54:33 +0000 |
| commit | fd63a4a63532aed40786de3f061796d17673eabe (patch) | |
| tree | 146f2374b8fc71ed0d6ce6c78b2fc37a8cb07615 /LedgerSMB/RC.pm | |
| parent | 19fe934f445c8f15b476f8cba1c3cbf449a59995 (diff) | |
Fixing error searching by address
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1263 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB/RC.pm')
| -rw-r--r-- | LedgerSMB/RC.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/LedgerSMB/RC.pm b/LedgerSMB/RC.pm index 6ffc16bf..e3517044 100644 --- a/LedgerSMB/RC.pm +++ b/LedgerSMB/RC.pm @@ -300,7 +300,7 @@ sub payment_transactions { FROM acc_trans ac JOIN chart ch ON (ac.chart_id = ch.id) JOIN ar a ON (a.id = ac.trans_id) - JOIN customer n ON (n.id = a.customer_id) + JOIN customer n USING (entity_id) WHERE ch.accno = | . $dbh->quote( $form->{accno} ) . qq| $fx_transaction $cleared|; $query .= " AND ac.transdate >= " . $dbh->quote( $form->{fromdate} ) @@ -335,7 +335,7 @@ sub payment_transactions { $query = qq| SELECT c.name FROM customer c - JOIN ar a ON (c.id = a.customer_id) + JOIN ar a using (entity_id) JOIN acc_trans ac ON (a.id = ac.trans_id) JOIN chart ch ON (ac.chart_id = ch.id) WHERE ac.transdate = ? @@ -368,7 +368,7 @@ sub payment_transactions { $query = qq| SELECT c.name FROM customer c - JOIN ar a ON (c.id = a.customer_id) + JOIN ar a USING (entity_id) JOIN acc_trans ac ON (a.id = ac.trans_id) JOIN chart ch ON (ac.chart_id = ch.id) WHERE ac.transdate = ? |