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