From 3d893fd09ed3408cb3680a4a752a3f137f6d5468 Mon Sep 17 00:00:00 2001 From: Mitch Jackson Date: Sun, 20 Jan 2019 16:14:12 -0500 Subject: [PATCH] RT# 80488 Validation on cust_location.district values --- FS/FS/cust_location.pm | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) diff --git a/FS/FS/cust_location.pm b/FS/FS/cust_location.pm index 63492dd33..21bf92feb 100644 --- a/FS/FS/cust_location.pm +++ b/FS/FS/cust_location.pm @@ -443,6 +443,26 @@ sub check { && $conf->exists('prospect_main-alt_address_format') && ! $self->location_kind; + # Do not allow bad tax district values in cust_location when + # using Washington State district sales tax calculation - would result + # in incorrect or missing sales tax on invoices. + my $tax_district_method = FS::Conf->new->config('tax_district_method'); + if ( + $tax_district_method + && $tax_district_method eq 'wa_sales' + && $self->district + ) { + my $cust_main_county = qsearchs( + cust_main_county => { district => $self->district } + ); + unless ( ref $cust_main_county ) { + return sprintf ( + 'WA State tax district %s does not exist in tax table', + $self->district + ); + } + } + unless ( $import or qsearch('cust_main_county', { 'country' => $self->country, 'state' => '', -- 2.11.0