Newbie and Canadaian taxes

[robbbb]

I am not sure if I am doing this properly or not. I am trying to post a message about oscommerce and installing correct Canadian taxes. I have watched a contribution article in the contributions section, however I cannot get my site to work properly. I am not blaming the article since it probably is me. The problem is I cannot get it to work and there seems to very little other sources out there addressing the Canadian tax system with oscommerce. Is there anyone with experence in the canadian tax setup that could steer me with hints or directions. When I go to my tax zones this is the info on that screen.

 

Tax Zones

 

Tax Zones Action

ON

Displaying 1 to 1 (of 1 tax zones) Page 1 of 1

 

 

ON

 

 

Number of Zones: 0

 

Date Added: 04/13/2005

Last Modified: 04/16/2005

 

Description:

Ontario

 

 

Tax Zones

 

 

When I click on the details button this is the message I get there. Can anybody help?

 

Country Zone Action

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

 

select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 2 order by association_id limit -20, 20

[timmitra]

Hi,

 

I had the same problem last week and found this under contributions...

 

http://www.oscommerce.com/community/contributions,1124

 

The problem is we have the GST and various provincial scams, I mean, schemes! The contribution also helps with the PST and HST for the provinces... You may also want to note that Shipping is subject to provincial tax but not GST - this contribution explains that too!

 

BTW I'm still trying to figure out how to deal with PST Exempt companies... If anyone knows how to deal with that I'd like to know...

 

Tim