summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-14 21:38:06 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-14 21:38:06 +0000
commit3cc940ef3d67dcc2a717fa0bc5245dfd1c6a7271 (patch)
tree027266a8061584cf64bb0a141a074d7557ff887a /sql
parent03688c1557a42e17bff85f01aa7af6cef66a70a1 (diff)
fixed ar_ap_summary_fix again.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2144 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/fixes/ar_ap_summary_fix_1.2.14.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/fixes/ar_ap_summary_fix_1.2.14.sql b/sql/fixes/ar_ap_summary_fix_1.2.14.sql
index 5f8bbdc5..2e20e3e3 100644
--- a/sql/fixes/ar_ap_summary_fix_1.2.14.sql
+++ b/sql/fixes/ar_ap_summary_fix_1.2.14.sql
@@ -18,7 +18,7 @@ SET netamount =
where trans_id = ap.id
AND ((chart_id IN
(select id from chart where link = 'AP')
- AND amount < 0)
+ AND amount > 0)
OR (chart_id IN
(select id from chart
where link like '%tax%')
@@ -49,7 +49,7 @@ SET netamount =
where trans_id = ar.id
AND ((chart_id IN (select id from chart
where link = 'AR')
- AND amount > 0)
+ AND amount < 0)
OR (chart_id IN
(select id from chart where link like '%tax%')
)