diff options
Diffstat (limited to 'LedgerSMB/AM.pm')
| -rw-r--r-- | LedgerSMB/AM.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/LedgerSMB/AM.pm b/LedgerSMB/AM.pm index 74034fd3..618c4d0b 100644 --- a/LedgerSMB/AM.pm +++ b/LedgerSMB/AM.pm @@ -969,7 +969,7 @@ sub recurring_transactions { AS expired FROM recurring s JOIN ar a ON (a.id = s.id) - JOIN customer n ON (n.id = a.customer_id) + JOIN customer n USING (entity_id) LEFT JOIN recurringemail se ON (se.id = s.id) LEFT JOIN recurringprint sp ON (sp.id = s.id) LEFT JOIN exchangerate ex @@ -1024,7 +1024,7 @@ sub recurring_transactions { AS expired FROM recurring s JOIN oe a ON (a.id = s.id) - JOIN customer n ON (n.id = a.customer_id) + JOIN customer USING (entity_id) LEFT JOIN recurringemail se ON (se.id = s.id) LEFT JOIN recurringprint sp ON (sp.id = s.id) LEFT JOIN exchangerate ex ON |