better behavior when zip code is missing

1 files changed, 4 insertions, 1 deletions

diff --git a/httemplate/edit/cust_main/choose_tax_location.html b/httemplate/edit/cust_main/choose_tax_location.html
index 23fdbf282..045490b55 100644
--- a/httemplate/edit/cust_main/choose_tax_location.html
+++ b/httemplate/edit/cust_main/choose_tax_location.html
@@ -50,7 +50,10 @@ my $hashref = { data_vendor => $data_vendor,
 my @keys = qw ( zip );
 my @cust_tax_location = ();
 until ( @cust_tax_location ) {
-  @cust_tax_location = qsearch( 'cust_tax_location', $hashref );
+  @cust_tax_location = qsearch({ table    => 'cust_tax_location',
+                                 hashref  =>  $hashref,
+                                 order_by =>  'LIMIT 50',
+                              });
   last unless scalar(@keys);
   delete $hashref->{ shift @keys };
 }