X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAR.pm;h=77c62d39c4e5d97e6b5373144ed08014772f95e5;hb=9f0c5105e2c79feead651fd0de5d9ba725a2c1ff;hp=b856f44a73e1c70007bf7e4b8d7bf26069e94d5c;hpb=6ceacc682f9c760e654f5aacde9b8480760d8b36;p=kivitendo-erp.git diff --git a/SL/AR.pm b/SL/AR.pm index b856f44a7..77c62d39c 100644 --- a/SL/AR.pm +++ b/SL/AR.pm @@ -487,6 +487,7 @@ sub ar_transactions { qq| a.shippingpoint, a.storno, a.storno_id, a.globalproject_id, | . qq| a.marge_total, a.marge_percent, | . qq| a.transaction_description, a.direct_debit, | . + qq| a.type, | . qq| pr.projectnumber AS globalprojectnumber, | . qq| c.name, c.customernumber, c.country, c.ustid, b.description as customertype, | . qq| c.id as customer_id, | . @@ -575,7 +576,7 @@ sub ar_transactions { $where .= " AND a.department_id = ?"; push(@values, $form->{department_id}); } - foreach my $column (qw(invnumber ordnumber cusordnumber notes transaction_description)) { + foreach my $column (qw(invnumber ordnumber cusordnumber notes transaction_description shipvia shippingpoint)) { if ($form->{$column}) { $where .= " AND a.$column ILIKE ?"; push(@values, like($form->{$column}));