X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/56f7991d4910ae12c7d16aab025a2ab242ca5eeb..fdebfd5d0c558cb156849b01c9c9268b29dc443b:/SL/DB/Manager/Invoice.pm?ds=inline

diff --git a/SL/DB/Manager/Invoice.pm b/SL/DB/Manager/Invoice.pm
index 493789e84..5dc943f85 100644
--- a/SL/DB/Manager/Invoice.pm
+++ b/SL/DB/Manager/Invoice.pm
@@ -20,6 +20,7 @@ sub type_filter {
   return (and => [ invoice => 1, amount  => { lt => 0 }, or => [ storno => 0, storno => undef ] ]) if $type eq 'credit_note';
   return (and => [ invoice => 1, amount  => { lt => 0 },         storno => 1                    ]) if $type =~ m/(?:invoice_)?storno/;
   return (and => [ invoice => 1, amount  => { ge => 0 },         storno => 1                    ]) if $type eq 'credit_note_storno';
+  return (amount => {gt => 'paid'}) if $type eq 'open';
 
   die "Unknown type $type";
 }
@@ -34,7 +35,7 @@ sub _sort_spec {
     },
     columns                   => {
       SIMPLE                  => 'ALL',
-      customer                => 'customer.name',
+      customer                => 'lower(customer.name)',
       globalprojectnumber     => 'lower(globalproject.projectnumber)',
 
       # Bug in Rose::DB::Object: the next should be