X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/baceb8e5ce8ee53a5bd81db430ba46e9606b5ca5..76cad4416d845e3fe0e8a07e6288c785e52f134d:/SL/AP.pm diff --git a/SL/AP.pm b/SL/AP.pm index 956528317..e21eb13ea 100644 --- a/SL/AP.pm +++ b/SL/AP.pm @@ -450,6 +450,7 @@ sub ap_transactions { qq|SELECT a.id, a.invnumber, a.transdate, a.duedate, a.amount, a.paid, | . qq| a.ordnumber, v.name, a.invoice, a.netamount, a.datepaid, a.notes, | . qq| a.globalproject_id, a.storno, a.storno_id, a.direct_debit, | . + qq| a.transaction_description, | . qq| pr.projectnumber AS globalprojectnumber, | . qq| e.name AS employee, | . qq| v.vendornumber, v.country, v.ustid, | . @@ -533,6 +534,10 @@ sub ap_transactions { $where .= " AND a.ordnumber ILIKE ?"; push(@values, like($form->{ordnumber})); } + if ($form->{transaction_description}) { + $where .= " AND a.transaction_description ILIKE ?"; + push(@values, like($form->{transaction_description})); + } if ($form->{notes}) { $where .= " AND lower(a.notes) LIKE ?"; push(@values, like($form->{notes}));