diff options
| author | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-02 23:24:28 +0000 |
|---|---|---|
| committer | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-02 23:24:28 +0000 |
| commit | da36e0095ae8b05e124507abd70b7122a94c15f1 (patch) | |
| tree | e2c0fe8d0bfbf6643af697877218453fa054d9cb /LedgerSMB/RC.pm | |
| parent | 24fa7eca64770b4c2fe9690ba88d77d9ba1f1b75 (diff) | |
Change defaults queries to using new table structure
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@469 4979c152-3d1c-0410-bac9-87ea11338e46
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'|; |