From 2d881637843afa5483ddf7c22b8dafd22c5305c0 Mon Sep 17 00:00:00 2001 From: Niclas Zimmermann Date: Tue, 19 Feb 2013 12:03:47 +0100 Subject: [PATCH] =?utf8?q?tax=5Fid/taxkey=20bei=20SEPA-=C3=9Cberweisungen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Bei SEPA-Überweisungen wird jetzt auch tax_id und taxkey in die acc_trans geschrieben. Behebt Bug #2169. --- SL/SEPA.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/SL/SEPA.pm b/SL/SEPA.pm index e07fdcaf5..ea3531291 100644 --- a/SL/SEPA.pm +++ b/SL/SEPA.pm @@ -357,8 +357,8 @@ sub post_payment { AND ((c.link LIKE '%:${ARAP}') OR (c.link LIKE '${ARAP}:%') OR (c.link = '${ARAP}')) LIMIT 1| ], - 'add_acc_trans' => [ qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, gldate, source, memo) - VALUES (?, ?, ?, ?, current_date, ?, '')| ], + 'add_acc_trans' => [ qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, gldate, source, memo, taxkey, tax_id) + VALUES (?, ?, ?, ?, current_date, ?, '', 0, (SELECT id FROM tax WHERE taxkey=0 LIMIT 1))| ], 'update_arap' => [ qq|UPDATE ${arap} SET paid = paid + ? -- 2.20.1