From 14ce300bf9138ae4cf9412673ccf20eb9f20fcff Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 21 Mar 2008 18:43:55 +0000 Subject: 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 --- sql/modules/Voucher.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') 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)); -- cgit v1.2.3