X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=inline;f=SL%2FBP.pm;h=e1e0b82e9a45d5adfdf52fedffeb037259d6448c;hb=4a648176621310d6b0c099c7f7af2d5a8ecf0890;hp=2122a51d7ff8ed9e14384825dd8f57b599054b9a;hpb=d319704a66e9be64da837ccea10af6774c2b0838;p=kivitendo-erp.git

diff --git a/SL/BP.pm b/SL/BP.pm
index 2122a51d7..e1e0b82e9 100644
--- a/SL/BP.pm
+++ b/SL/BP.pm
@@ -180,12 +180,14 @@ sub get_spoolfiles {
     $query .= " AND lower(a.quonumber) LIKE '$quonumber'";
   }
 
-  #  $query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom};
-  #  $query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto};
+  if ($form->{type} =~ /(invoice|sales_order|sales_quotation)$/) {
+    $query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom};
+    $query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto};
+  }
 
   my @a = (transdate, $invnumber, name);
   my $sortorder = join ', ', $form->sort_columns(@a);
-  $sortorder = $form->{sort} unless $sortorder;
+  $sortorder = $form->{sort} if $form->{sort};
 
   $query .= " ORDER by $sortorder";