diff options
| -rw-r--r-- | LedgerSMB/AA.pm | 5 | ||||
| -rw-r--r-- | bin/aa.pl | 3 |
2 files changed, 7 insertions, 1 deletions
diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm index f42ab0e7..3621180b 100644 --- a/LedgerSMB/AA.pm +++ b/LedgerSMB/AA.pm @@ -828,6 +828,9 @@ sub transactions { my $sortorder = $form->sort_order( \@a, \%ordinal ); my $where = "1 = 1"; + if ($form->{"meta_number"}){ + $where .= " AND vc.meta_number = " . $dbh->quote($form->{meta_number}); + } if ( $form->{"$form->{vc}_id"} ) { $form->{entity_id} = $form->{$form->{vc}."_id"}; $where .= qq| AND a.entity_id = $form->{entity_id}|; @@ -835,7 +838,7 @@ sub transactions { else { if ( $form->{ $form->{vc} } ) { $var = $dbh->quote( $form->like( lc $form->{ $form->{vc} } ) ); - $where .= " AND lower(vc.name) LIKE $var"; + $where .= " AND lower(vce.name) LIKE $var"; } } @@ -1427,6 +1427,9 @@ qq|<input name="l_transdate" class=checkbox type=checkbox value=Y checked> | <th align=right>$name</th> <td colspan=3>$selectname</td> </tr> + <tr><th align="right">|.$locale->text('Number').qq|</th> + <td colspan="3"><input name="meta_number" size="36"> + </tr> $employee $department $invnumber |