From 3cc940ef3d67dcc2a717fa0bc5245dfd1c6a7271 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 14 May 2008 21:38:06 +0000 Subject: 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 --- sql/fixes/ar_ap_summary_fix_1.2.14.sql | 4 ++-- 1 file 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%') ) -- cgit v1.2.3