From f12fcb594dd079ca987edca36cd431a3a2ef155e Mon Sep 17 00:00:00 2001 From: Philip Reetz Date: Mon, 26 Feb 2007 15:03:24 +0000 Subject: [PATCH] Eine Aenderung zuviel in den Abfragen: Lieferdatum wurde nicht mehr berucksichtigt --- SL/USTVA.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/SL/USTVA.pm b/SL/USTVA.pm index d7e2e428e..f69cd2dd3 100644 --- a/SL/USTVA.pm +++ b/SL/USTVA.pm @@ -739,7 +739,7 @@ sub get_accounts_ustva { SELECT id FROM taxkeys WHERE chart_id = ac.chart_id -- AND taxkey_id = ac.taxkey - AND startdate <= COALESCE(ar.transdate) + AND startdate <= COALESCE(ar.deliverydate,ar.transdate) ORDER BY startdate DESC LIMIT 1 ) ) @@ -777,7 +777,7 @@ sub get_accounts_ustva { tk.id = ( SELECT id FROM taxkeys WHERE chart_id = ac.chart_id - AND startdate <= COALESCE(ar.transdate) + AND startdate <= COALESCE(ar.deliverydate,ar.transdate) ORDER BY startdate DESC LIMIT 1 ) ) -- 2.20.1