From 4536d0a7bc1b0b014cdac7211dcc171973678dbf Mon Sep 17 00:00:00 2001 From: Udo Spallek Date: Wed, 9 May 2007 07:36:47 +0000 Subject: [PATCH] Die USTVA darf nicht nach dem Taxkey abfragen, weil dieser nichts damit zu tun hat. Fuer die USTVA sind nur die pos_ustva von Relevanz. --- SL/USTVA.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/USTVA.pm b/SL/USTVA.pm index 9f1551ed4..f99021f9a 100644 --- a/SL/USTVA.pm +++ b/SL/USTVA.pm @@ -912,7 +912,7 @@ sub get_accounts_ustva { SELECT id FROM taxkeys WHERE 1=1 AND chart_id=ac.chart_id - AND taxkey_id = ac.taxkey + --AND taxkey_id = ac.taxkey AND startdate <= COALESCE(AP.transdate) ORDER BY startdate DESC LIMIT 1 ) -- 2.20.1