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