tax_id/taxkey bei SEPA-Überweisungen

Bei SEPA-Überweisungen wird jetzt auch tax_id und taxkey in die
acc_trans geschrieben.

Behebt Bug #2169.

diff --git a/SL/SEPA.pm b/SL/SEPA.pm
index e07fdcaf53bc0e356700e38a62d1beb10891a870..ea35312913d10543bb906b93663bf908c209c87c 100644 (file)
--- 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 + ?