HomeHome Product Discus... Product Discus...SmithCartSmithCartTax SetupTax Setup
Previous
 
Next
New Post
10/23/2009 8:02 AM
 

First, I'd like to set up taxes so only Minnesota orders are charged a 7.5% tax.

Is this the correct configuration:

Charge Tax All: Not Checked

Tax Rate: 7.5

Use Tax Tables: Not Checked

Default Country: United States

Home State: Minnesota

Secondly, I'm unsure about use of the Tax Tables. Are the tax tables included in Smith Cart or do I need to upload tax tables to the site? If I were to use the tax table option for the same tax requirement above would the following configuration be correct:

Charge Tax All: Not Checked

Tax Rate: blank

Use Tax Tables: Checked

Default Country: United States

Home State: Minnesota

 
New Post
10/23/2009 1:55 PM
 

You have your settings correct

Charge Tax All: Not Checked

Tax Rate: blank

Use Tax Tables: Checked

Default Country: United States

Home State: Minnesota

You can set the tax rate to 7.5% for all customers who buy from Minn. by adding the highlighted section below to the following stored proc or just running this stored proc from sql mgmt studio. We will be adding this to the cart settings screen in the next release.

ALTER PROCEDURE [dbo].[Smith_GetTaxRate]

@CityName VARCHAR(255) ,

@State VARCHAR(50)

AS

IF ( @State = 'CT')

BEGIN

SELECT '6' AS [TaxRate]

END

ELSE IF ( @State = 'MI')

BEGIN

SELECT '6.5' AS [TaxRate]

END

ELSE IF ( @State = 'MN')

BEGIN

SELECT '7.5' AS [TaxRate]

END

ELSE

BEGIN

SELECT [TaxRate] FROM Smith_Tax

WHERE lower([City]) like lower(@CityName)

AND lower([State]) like (@State)

END


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartTax SetupTax Setup