summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/fixes/ar_ap_summary_fix_1.2.14.sql7
1 files changed, 3 insertions, 4 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 2e20e3e3..e1c11d8d 100644
--- a/sql/fixes/ar_ap_summary_fix_1.2.14.sql
+++ b/sql/fixes/ar_ap_summary_fix_1.2.14.sql
@@ -13,12 +13,11 @@ SET netamount =
)
)
ELSE
- -1 *
(select sum(amount) from acc_trans
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%')
@@ -44,12 +43,12 @@ SET netamount =
)
)
)
- ELSE
+ ELSE -1 *
(select sum(amount) from acc_trans
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%')
)