From e99f795f9bc71f46b27c29b692e7f10c3b052846 Mon Sep 17 00:00:00 2001 From: Udo Spallek Date: Tue, 20 Jun 2006 11:10:09 +0000 Subject: [PATCH] r1157 rueckgaengig gemacht (aus Testzwecken) --- SL/USTVA.pm | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) diff --git a/SL/USTVA.pm b/SL/USTVA.pm index 3cb7ff816..c27d9377c 100644 --- a/SL/USTVA.pm +++ b/SL/USTVA.pm @@ -724,10 +724,7 @@ sub get_accounts_ustva { UNION - SELECT sum( - CASE WHEN c.link LIKE '%AR%' THEN ac.amount * -1 - WHEN c.link LIKE '%AP%' THEN ac.amount * 1 - END + SELECT sum(ac.amount ) AS amount, c.$category FROM acc_trans ac -- 2.20.1