X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2d881637843afa5483ddf7c22b8dafd22c5305c0..1672583af0518aaa1b73d3fb0a7e4a07d5329ffc:/SL/AM.pm diff --git a/SL/AM.pm b/SL/AM.pm index c7a88d2df..5645c4dd7 100644 --- a/SL/AM.pm +++ b/SL/AM.pm @@ -1779,7 +1779,9 @@ sub get_tax { taxkey, taxdescription, round(rate * 100, 2) AS rate, - chart_id + chart_id, + (id IN (SELECT tax_id + FROM acc_trans)) AS tax_already_used FROM tax WHERE id = ? |;