summaryrefslogtreecommitdiff
path: root/sql/modules
diff options
context:
space:
mode:
Diffstat (limited to 'sql/modules')
-rw-r--r--sql/modules/Payment.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql
index a0a36b3c..1f31c697 100644
--- a/sql/modules/Payment.sql
+++ b/sql/modules/Payment.sql
@@ -185,7 +185,7 @@ BEGIN
FROM ar
WHERE in_account_class = 2
ORDER BY transdate
- ) a USING (entity_id)
+ ) a ON (a.entity_credit_account = c.id)
JOIN transactions t ON (a.id = t.id)
LEFT JOIN voucher v ON (v.trans_id = a.id)
WHERE v.batch_id = in_batch_id