HomeHome Product Discus... Product Discus...SmithCartSmithCart"Use Tax Tables" not working for Products with no Shipping"Use Tax Tables" not working for Products with no Shipping
Previous
 
Next
New Post
6/4/2011 3:39 PM
 

I am trying to set up custom (Canadian Provinces) tax rates. I got it to work at one point, but now it returns a tax rate of 0%. (I have read through "http://www.smith-consulting.com/Forums/forumid/13/threadid/5426/scope/posts.aspx")

My setting are attached:

  • DNN: 5.6.1

  • SmithCart: 4.24 (I'm in the middle of an extensive customization and would really prefer not to upgrade at this point)

  • "Use Tax Tables" is selected

  • "Use Step1 Dropdown List in Tax Lookup" is Unchecked

  • "Enable Tax Exempt by Role" is Unchecked

  • "Enable VAT/GST" is Unchecked

  • Product "Tax Exempt" is Unchecked

Here is my Smith_Tax table:


TaxId State County City TaxRate
1765 NS     15
1770 AB     5
1771 BC     12
1772 MB     5
1773 NB     13
1774 NL     13
1775 NT     5
1776 NU     5
1777 ON     13
1778 PE     5
1779 QC     5
1780 SK     5
1781 YT     5

 



I even hard-coded the 'Smith_GetTaxRate' stored procedure to return the value '7' regardless:


 ALTER PROCEDURE dbo.Smith_GetTaxRate @CityName VARCHAR(255) , @State VARCHAR(50) AS SELECT '7' AS [TaxRate] 

and I am still getting 0% as a tax rate (see attached)


Note that this did work at one point. Then I cleared the California section so I would not charge my California customers sales tax:


 DELETE FROM Smith_Tax WHERE State='CA'

It seemed to stop working after that, although I'm not sure there is a connection.


Please tell me how I can get this to work

 
 Login to download attachment
New Post
6/4/2011 3:54 PM
 

I am using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1

Here is some additional information: The 'download' version of our products have a weight of zero, and therefore no Shipping Charges. An order with only downloadable products shows zero Sales Tax (even though there should be tax).

When a CD-ROM is included in the order, there is a Shipping Charge, and the tax suddenly appears correctly. It seems a product with Shipping triggers the "Ship To" dialog, which forces the customer to select a "State/Region" from the drop-down box.

The SmithCart needs to pick up the State/Region, for tax purposes, from the Customer information already available, without depending on the "Ship To" dialog that is never triggered.

How can this be fixed, and how soon? We are ready to go live with the Shopping Cart, this is holding us back.

Here is the Test version of our Shopping Cart:

http://dev.progenygenealogy.com/Produ...
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCart"Use Tax Tables" not working for Products with no Shipping"Use Tax Tables" not working for Products with no Shipping