HomeHome Product Discus... Product Discus...SmithCartSmithCartTax Tables that include Flat Tax StatesTax Tables that include Flat Tax States
Previous
 
Next
New Post
1/27/2011 1:13 PM
 
Craigjb12
No Ranking


Joined: 1/27/2011
Posts: 20

I need to include 7 states for the tax tables

4 of them have state, county, city and tax rate data - this data I have imported into Smith_Tax

however the remaining 3 have a flat rate of 7% for all cities in the state

I'm not sure how to best accomplish adding this without pasting in a full list of all the cities by county in each state.

Thanks in advance
 
New Post
1/27/2011 9:00 PM
Accepted Answer 
No Ranking

Joined: 1/1/0001
Posts: 0

This can be done by editing the dnn_Smith_GetTaxRate sproc in your database (Located at Programmability>Stored Procedures>dnn_Smith_GetTaxRate) in SQL Server Management Studio. Highlighted in yellow below is what you need to edit:

IF ( @State = 'LL') /*****change LL to the state you want****/

BEGIN
SELECT '7' AS [TaxRate]
END
ELSE IF ( @State = 'CA') /*****change CA to the state you want****/
BEGIN
SELECT '7' AS [TaxRate]
END
ELSE IF ( @State = 'CO') /*****change CO to the state you want****/
BEGIN
SELECT '7' AS [TaxRate]
END
ELSE
BEGIN
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
END
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartTax Tables that include Flat Tax StatesTax Tables that include Flat Tax States




Questions? Contact us for answers!

Contact Us!