summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-03-21 18:43:55 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-03-21 18:43:55 +0000
commit14ce300bf9138ae4cf9412673ccf20eb9f20fcff (patch)
tree2d97417a02d88cca3900bc8f1a63040c67d04992 /sql
parent635395c51afa1b60d892ae5f28f4e2250d7996b5 (diff)
Correcting problem with batch posts only posting some payments.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2110 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Voucher.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Voucher.sql b/sql/modules/Voucher.sql
index 4cf04c6a..c9d6cc60 100644
--- a/sql/modules/Voucher.sql
+++ b/sql/modules/Voucher.sql
@@ -235,7 +235,7 @@ BEGIN
AND batch_class = 5);
UPDATE acc_trans SET approved = true
- WHERE trans_id IN (select trans_id FROM voucher
+ WHERE voucher_id IN (select id FROM voucher
WHERE batch_id = in_batch_id
AND batch_class IN (3, 4, 7, 8));