From df52f854e367f6342e480c22cb6ec7b8244fd334 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sat, 15 Dec 2007 01:37:02 +0000
Subject: [PATCH] where helps alot

---
 httemplate/search/cust_bill.html | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/httemplate/search/cust_bill.html b/httemplate/search/cust_bill.html
index b7eac57ea..fe2f6e5f8 100755
--- 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',
-- 
2.11.0