X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/311a645bc3b3a74052c7c0565afaad77961102a8..e99f795f9bc71f46b27c29b692e7f10c3b052846:/SL/USTVA.pm 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