X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/6c0a55aca160c95f56fd52196d946a0708a2c7b5..7635f647ec7dcdef51684b21601ee0930ea2bc5b:/SL/TransNumber.pm diff --git a/SL/TransNumber.pm b/SL/TransNumber.pm index 859ca6865..9d6d2993a 100644 --- a/SL/TransNumber.pm +++ b/SL/TransNumber.pm @@ -71,7 +71,6 @@ sub _get_filters { $filters{numberfield} = $type eq 'service' ? 'servicenumber' : 'articlenumber'; $filters{numberfield} = $type eq 'assembly' ? 'assemblynumber' : $filters{numberfield}; $filters{table} = "parts"; - $filters{where} = 'COALESCE(inventory_accno_id, 0) ' . ($type eq 'service' ? '= 0' : '<> 0 OR assembly'); } return %filters;