diff options
| author | Mark Wells <mark@freeside.biz> | 2012-04-25 11:26:36 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-04-25 11:26:36 -0700 |
| commit | 5fd66da492a1b206fa4e944eb0caa2e2642d454a (patch) | |
| tree | 0bd9b1b8fc8222572d1bf69d2f4b4d20dc5249f3 /FS/FS/cust_main_county.pm | |
| parent | 998dcad2d8f4b8e22b9a2f042f006b9167b8cdf3 (diff) | |
consider districts in tax liability report, #17051
Diffstat (limited to 'FS/FS/cust_main_county.pm')
| -rw-r--r-- | FS/FS/cust_main_county.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_main_county.pm b/FS/FS/cust_main_county.pm index e937b20..6316f23 100644 --- a/FS/FS/cust_main_county.pm +++ b/FS/FS/cust_main_county.pm @@ -176,7 +176,7 @@ with different tax classes. sub sql_taxclass_sameregion { my $self = shift; - my $same_query = 'SELECT taxclass FROM cust_main_county '. + my $same_query = 'SELECT DISTINCT taxclass FROM cust_main_county '. ' WHERE taxnum != ? AND country = ?'; my @same_param = ( 'taxnum', 'country' ); foreach my $opt_field (qw( state county )) { |