diff options
Diffstat (limited to 'LedgerSMB/RC.pm')
| -rwxr-xr-x | LedgerSMB/RC.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/LedgerSMB/RC.pm b/LedgerSMB/RC.pm index 7ba6770a..48f184cd 100755 --- a/LedgerSMB/RC.pm +++ b/LedgerSMB/RC.pm @@ -232,11 +232,11 @@ sub payment_transactions { if ($form->{fx_transaction}) { $fx_transaction = qq| AND NOT (ac.chart_id IN - (SELECT value AS fxgain_accno_id FROM defaults + (SELECT value FROM defaults WHERE setting_key = 'fxgain_accno_id' UNION - SELECT value AS fxloss_accno_id FROM defaults - WHERE setting_key = 'fxloss_accno_id))|; + SELECT value FROM defaults + WHERE setting_key = 'fxloss_accno_id'))|; } else { $fx_transaction = qq| AND ac.fx_transaction = '0'|; |