diff options
| -rwxr-xr-x | LedgerSMB/RC.pm | 6 | ||||
| -rw-r--r-- | dists/deb/cpan_requisites.txt | 1 |
2 files changed, 4 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'|; diff --git a/dists/deb/cpan_requisites.txt b/dists/deb/cpan_requisites.txt index e1b0e1ae..b2636dea 100644 --- a/dists/deb/cpan_requisites.txt +++ b/dists/deb/cpan_requisites.txt @@ -1,2 +1,3 @@ Config::Std Class::Std +Build |