X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FBP.pm;h=e1e0b82e9a45d5adfdf52fedffeb037259d6448c;hb=6c9677e4fde52aae481cc004895d506812ca8d67;hp=e776954260e9d83aad493a0093abf390225a616b;hpb=993f05d0c65e9f1c990364303c7474cf0873f429;p=kivitendo-erp.git diff --git a/SL/BP.pm b/SL/BP.pm index e77695426..e1e0b82e9 100644 --- a/SL/BP.pm +++ b/SL/BP.pm @@ -180,8 +180,10 @@ 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);