HomeHome Product Discus... Product Discus...SmithCartSmithCartSome states taxable, others not.Some states taxable, others not.
Previous
 
Next
New Post
6/22/2010 11:52 AM
 

How do I go about charging tax for some states, but not others. I see an all state option, the homestate option and a tax table option. When I looked at the DNN_Smith_Tax Table I see only California towns. Is there an option for NJ, PA, CT, DE, and NY? If not, do I have to put in each individual town for all five states into this table? The documentation says that only customers in the home state will be charged. How is this different than the "Charge Tax" in Home state method? You have to collect sales tax for any state where a company has an office. That's my dilemma.

 
New Post
6/23/2010 11:49 AM
 

In the cart settings if you select the "Use Tax Tables" option and then the cart will lookup the tax rate in the tax tables. You will then need to go into sql mgmt studio and populate the tax rates for the states you want to charge tax for in your case (NJ, PA, CT, DE, and NY). The easiest way to populate the “Smith_Tax” table is to go into SQL Management Studio and right click the smith_tax table and click "import" and follow the wizard. You can download the tax rates for the states you want from the .gov sites for the states you want to charge tax for.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/23/2010 1:49 PM
 

Ok, so the tax is not just charged for your "Home State", for me, NJ, as you have written on Page 47 of your documentation:

"Use Tax Tables – Choose this option if you want the store to lookup the exact tax rate in the tax tables. If you select this option only customers in your "Home State" will be charged tax. To modify, add or import records to the tax table go to your SQL Management Studio and choose the table called "Smith_Tax". "

But actually "Home State" is any set of states that you put in the table. If the towns in NJ, PA, DE, CT, and NY are entered, then if the customer is in any of those states and towns, they get charged tax. If the customer is in Ohio and Ohio isn't in the Smith Tax table then Ohioans don't get charged tax in my example. When I read Home State as it is in the documentation I think only of one state, not a set. A bit confusing, I think.

 
New Post
6/23/2010 1:58 PM
 

Yes I agree that is how it is documented in the manual but we looked at the code and if you populate the tax table for multiple states it should do a lookup on all the records in the tax table and charge tax. Its more flexiable that way andwe will change the doc to reflect that.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/25/2010 1:54 PM
 

Does the county really count? If I put the state and the towns with their rates and put the county as all the same, will there be a problem? I can't find any lists of state, county, town on line. I see State and Towns, or States and Counties. But no state, county town.

Will it make a difference if I put all NJ towns in say, Bergen County and then all with 7% tax? Is there a place in check out for county anyway?

 
New Post
6/25/2010 2:03 PM
 

County is not used its either a lookup on state and city or just state. Here is the logic in the Smith_GetTaxRate stored proc:

if (@CityName = '')
BEGIN
SELECT [TaxRate] FROM dnn_Smith_Tax WHERE lower([State]) like (@State)
END
else
BEGIN
SELECT [TaxRate] FROM dnn_Smith_Tax WHERE lower([City]) like lower(@CityName) AND lower([State]) like (@State)
END


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/25/2010 2:07 PM
 

Perfect ! Thank you. That was exactly the information I needed.

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSome states taxable, others not.Some states taxable, others not.