X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/677204243cca2c51e33c93a17945a98fdbf835a5..a5501b166388f169f232af20d911d79528f2f5c5:/SL/Form.pm diff --git a/SL/Form.pm b/SL/Form.pm index a1e6a4d9d..dbffe1ff7 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -1697,7 +1697,7 @@ sub _get_customers { $key = "all_customers" unless ($key); - my $query = qq|SELECT * FROM customer ORDER BY name|; + my $query = qq|SELECT * FROM customer WHERE NOT obsolete ORDER BY name|; $self->{$key} = selectall_hashref_query($self, $dbh, $query); @@ -1711,7 +1711,7 @@ sub _get_vendors { $key = "all_vendors" unless ($key); - my $query = qq|SELECT * FROM vendor ORDER BY name|; + my $query = qq|SELECT * FROM vendor WHERE NOT obsolete ORDER BY name|; $self->{$key} = selectall_hashref_query($self, $dbh, $query);