X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4dc48e117cfdb6e59c2d8b9d8087ef8a3bc245a4..96ebad9d2e62a0aecef0c4436a9b5aa7d50f28e1:/SL/AR.pm 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}));