From a44bb343f0aa6e3305edf9c10b6c8a543a30e718 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Mon, 7 Mar 2022 09:43:46 +0100 Subject: [PATCH] =?utf8?q?DATEV-Export=20Steuerschl=C3=BCssel=2094=20?= =?utf8?q?=C3=BCbergeben,=20aber=20die=20Steuerbuchungen=20ausklammern?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DATEV.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/SL/DATEV.pm b/SL/DATEV.pm index 9dcfe0bdb..86cb729bc 100644 --- a/SL/DATEV.pm +++ b/SL/DATEV.pm @@ -543,6 +543,7 @@ sub generate_datev_data { $gl_itime_filter $gl_department_id_filter $gl_imported + AND NOT EXISTS (SELECT gl_id from ap_gl where gl_id = gl.id) $filter ORDER BY trans_id, acc_trans_id|; @@ -835,7 +836,7 @@ sub generate_datev_lines { } if ($transaction->[$i]->{'taxkey'}) { $taxkey = $transaction->[$i]->{'taxkey'}; - $taxkey = 0 if $taxkey == 94; # taxbookings are in gl + # $taxkey = 0 if $taxkey == 94; # taxbookings are in gl } if ($transaction->[$i]->{'charttax'}) { $charttax = $transaction->[$i]->{'charttax'}; -- 2.20.1