summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-12 18:57:17 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-12 18:57:17 +0000
commit0aca24c8a8797b392c177aec714c2f680b5098e9 (patch)
treede3799ad988f1efc7a0a918c72bd6b369ee5bb80 /sql
parent8001c32ae1623286aaf3081d30685c75cc8a9c77 (diff)
Final version of amount_blank_ap_transactions.sql fix
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2135 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/fixes/amount_blank_ap_transactions.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/fixes/amount_blank_ap_transactions.sql b/sql/fixes/amount_blank_ap_transactions.sql
index 924e0116..fa7ec4f2 100644
--- a/sql/fixes/amount_blank_ap_transactions.sql
+++ b/sql/fixes/amount_blank_ap_transactions.sql
@@ -16,8 +16,8 @@ WHERE netamount IS NULL;
UPDATE ar
SET netamount = -1 *
(select sum(amount) from acc_trans
- where trans_id = ap.id
- AND ((chart_id IN (select id from chart where link = 'AP')
+ where trans_id = ar.id
+ AND ((chart_id IN (select id from chart where link = 'AR')
AND amount < 0)
OR (chart_id IN
(select id from chart where link like '%tax%')