where helps alot

diff --git a/httemplate/search/cust_bill.html b/httemplate/search/cust_bill.html
index b7eac57..fe2f6e5 100755 (executable)
--- a/httemplate/search/cust_bill.html
+++ b/httemplate/search/cust_bill.html
@@ -124,8 +124,6 @@ if ( $cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/ ) {
     $orderby = "ORDER BY cust_bill.$field";
   }
 
-  $search{'newest_percust'} = 1 if $cgi->param('newest_percust');
-
   if ( $cgi->param('newest_percust') ) {
     $search{'newest_percust'} = 1;
     $count_query = "SELECT COUNT(DISTINCT cust_bill.custnum), 'N/A', 'N/A'";
@@ -146,7 +144,7 @@ if ( $cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/ ) {
                     '$%.2f outstanding balance',
                   ];
   }
-  $count_query .=  " FROM cust_bill $join_cust_main $extra_sql";
+  $count_query .=  " FROM cust_bill $join_cust_main WHERE $extra_sql";
 
   $sql_query = {
     'table'     => 'cust_bill',