[ic] tax based on zip code?

Barry Treahy, Jr. Treahy at MMaz.com
Wed Feb 16 23:15:21 EST 2005


DB wrote:

> In Ohio, sales tax must now be charged at different rates depending 
> upon the location (zip code) of the customer. Has anyone done such a 
> thing or am I going to have to get my hands dirty (or pay someone else 
> to?) I'm running 5.2 with mysql.
>
I asked this question just weeks ago and the silence was irritating 
since someone has to had to have dealt with this already.

For teh data source, one of the least expensive solutions I've found is 
a product from the 'Sales Tax Clearinghouse' which provides monthly or 
quarterly updates of the tax tables in a fixed record format.  I've 
already created a table with the imported values and will be working on 
a tags that will validate the zip,state,city combinations when a ship-to 
or account is setup and another to pull the current rates at the time of 
ordering...  If you're interested in working together on this, contact 
me off-list...

Barry

-- 

Barry Treahy, Jr                     E-mail: Treahy at MMaz.com
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President & CIO                      FAX:  480/661-7028

                       ... but it's a DRY HEAT!                          




More information about the interchange-users mailing list