Sales Tax Modification

[dc8johnson]

I know there has been significant discussion on sales tax for states like Washington and Florida but I think my question is more generic.

I would like to insert a check into the current sales tax calculation process. My code would do a lookup of the postal code in a customer supplied table. If the postal code was found, the lookup would return the tax rate name to use. If the postal code was not found, then I would to let the current AbleCommerce sales tax engine to take over.

Any thoughts from anyone?

Thanks,

David

[mazhar]

You can define tax rules specific to different zones. It seems to me you are trying to configure different taxes for different zones. Have a look at tax rules and zones configurations sections at help site
http://help.ablecommerce.com/mergedProj ... _taxes.htm

[dc8johnson]

We're trying to insert a check before the standard tax rule look up. My understanding is that right now you create tax rules for each postal code set. For states like Florida this apparently results in over 500 tax rules. According to this post:

viewtopic.php?f=42&t=12601&p=54318&hili ... ode#p54318

the site performs poorly when you get too many tax rules. Our thought was to insert a check before the current tax rules code runs. It would do a quick lookup in a data table for the user's postal code. If found, it would return the tax rule name, our code would then attach that tax rule to the products in the cart. If not found, the standard code would run and the current algorithm would determine the tax rule.

Using the code from this post:

viewtopic.php?f=47&t=7562

we can insert code into the lookup process to adjust the tax code. This process seems like it would require a one-to-one relationship between a tax code and tax rule. Is there a way we can do this for the tax rules so we don't have to have both a tax code and a tax rule? I don't see any data element in any of the ac_Order?? tables that stores the tax rule, so perhaps this one-to-one tax code to tax rule is necessary. But, if I understand it, if we used a service like Avalara, it would return the taxable amount. If that's correct, where would that taxable amount be stored?

Thanks,

[dc8johnson]

We ended up taking the Washington State code and modifying it. We created a database lookup table for postal code to tax code. We modified the TaxLookup.cs to perform a lookup in that database table instead of doing the webservice call. Seems to work well. If the postal code isn't in our lookup table then the standard AC lookup takes over.

Thanks for your help,

[robaorl]

There was and upgrade log posted for 7.04 for Wa State Tax
#8159 enhancement Providers Implement Washington state tax provider.
Does anyone know where I can find details of what this is, how it works?
Anything?

[mazhar]

There was and upgrade log posted for 7.04 for Wa State Tax
#8159 enhancement Providers Implement Washington state tax provider.
Does anyone know where I can find details of what this is, how it works?
Anything?

Read following thread
viewtopic.php?f=42&t=14141