X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Fwa_tax_rate_update;h=d4a4b52e48ff49bff2b0e0669d39915b3480757b;hp=2d493db309c8f9745df3c0941a37ab187254d5d7;hb=11bbf29de447fe39e9d7155fe280a0df70fa8c3c;hpb=2f83aa0920cd03724adf25b7ffb89890d43d96ce diff --git a/bin/wa_tax_rate_update b/bin/wa_tax_rate_update index 2d493db30..d4a4b52e4 100644 --- a/bin/wa_tax_rate_update +++ b/bin/wa_tax_rate_update @@ -78,6 +78,7 @@ my $total_skipped = 0; while ( !$csv->eof ) { my $line = $csv->getline_hr($fh); my $district = $line->{Code} or next; + $district = sprintf('%04d', $district); my $tax = sprintf('%.1f', $line->{Rate} * 100); my $changed = 0; my $skipped = 0; @@ -88,6 +89,7 @@ while ( !$csv->eof ) { district => $district, taxclass => $opt_c, taxname => $opt_t, + tax => { op => '>', value => '0' }, }); if ($opt_t eq '') { push @rates, qsearch('cust_main_county', { @@ -95,7 +97,8 @@ while ( !$csv->eof ) { state => 'WA', # this is specific to WA district => $district, taxclass => $opt_c, - taxname => 'Tax' + taxname => 'Tax', + tax => { op => '>', value => '0' }, }); } foreach my $rate (@rates) {