summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--httemplate/edit/cust_main/choose_tax_location.html5
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 };
}