diff options
Diffstat (limited to 'sql/fixes/ar_ap_summary_fix_1.2.14.sql')
| -rw-r--r-- | sql/fixes/ar_ap_summary_fix_1.2.14.sql | 7 |
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%') ) |