rickdeis

Thanks for your input Dan. Prior to receiving your reply I managed to partially solve a few of my problems but am still working on a complete resolution. I expect I'll have to tweak some of the code to get all situations to work properly though . I've managed to get the taxes working for any purchase (GST or HST Class Taxable Goods class) from any of the Canadian provinces/territories by creating a individual tax zone and tax rate for each and every Canadian provinces/territories. Also any purchase from the USA is not taxed at all. Here's how I set that up: This will allow me to easily change tax rates when any province makes a change. As I said it all works well for any products falling into the "GST or HST Class Taxable Goods" class but I will still have to work out my other classes of products. Please note the Canada PST only zone which I would like to marry to the "GST Class Taxable Goods " class for items like books or childrens clothes. I'll add more later. Rick

Hi Dan I was breaking the HST up into its two components with the thinking that some items ie are only charged GST. I guess that thinking may be flawed? HST is somewhat confusing as its 12% in BC, 13% in Ont, NFL & MB and 15% in NS. I just spoke to Revenue Canada and they've told me that I have to charge the HST to all HST provinces at their rates and GST to non HST provinces (except of course HST or GST exempt items/organizations) So what I've now done is to have created TAX ZONES Canada GST .......................SUB ZONE .......................................... Manitoba .......................................... Alberta .......................................... NWT .......................................... Nunavut ......................................... PEI ......................................... Quebec ......................................... Sask ......................................... Yukon Canada HST .......................SUB ZONE ..........................................Nova Scotia ..........................................Ontario ..........................................Newfoundland ..........................................New Brunswick ..........................................BC TAX CLASSES .........................................GST Class Taxable Goods ( GST only taxable items) .........................................GST or HST Class Taxable Goods .........................................Tax deferred class (for items like gift certificates) .........................................Tax Exempt class (for any personal items I list and non-taxable items) .........................................Taxable Goods (this one was just used for testing the site) TAX RATES.....................................................ZONE.....................................................RATE.....................................................Priority GST or HST Class Taxable Goods.........................Canada HST Goods.................................................12%.....................................................1 GST or HST Class Taxable Goods.........................Canada HST Goods.................................................13%.....................................................1 GST or HST Class Taxable Goods.........................Canada HST Goods.................................................15%.....................................................1 GST Class Taxable Goods......................................Canada GST Goods................................................. 5%.....................................................1 **** Unfortunately it doesn't allow me to choose Sub Zones and therefore doesn't work ***** For a BC purchaser the Product in the GST or HST Class taxable Goods category the checkout_confirmation page shows 27% Tax on the product line and the total info is: Sub-Total: $22.32 Flat Rate (Best Way): $5.00 BC HST #897400933RT0001: $3.28 Nova Scotia HST #897400933RT0001: $4.10 Total: $34.70 I think I'm digging a deeper hole? Does anyone have a tax module that works? Which files do I look at to see whats happening? Rick

Hey Cris, no I didn't as non Canadian purchases work fine as no HST or GST is charged for exports. Rick

Hi All Just installed OSC 2.3.1 plus the Canada Post shipping and Canada tax modules and am trying to work things out. I am in BC and have to charge taxes. A few strange things are happening which I will list later on but first here are my settings: Tax Zones Tax Zones British Columbia HST Country-------- Zone Canada ---------- British Columbia Tax Zones Canada GST Country-------- Zone Canada ---------- All Zones Tax Classes Tax Classes Non Taxable Goods Taxable Goods Tax Rates Priority ---- Tax Class---- Zone---- Tax Rate 2 --------- Taxable Goods ---- British Columbia HST---- 7.00% 2 --------- Taxable Goods ---- British Columbia HST ---- 5.00% 2 --------- Taxable Goods ---- Canada GST ------------- 5.00% All my products are given a Taxable Goods except "gift certificates" which are Non Taxable Goods. So all looks OK to me. I've set up 3 test purchases to test purchases from BC, other Canadian Provinces and the USA. Here's what happens: (dashes put in by me for readability) Test case 1 is a BC purchaser.(checkout_confirmation.php page) It shows 17% instead of 12% below the Tax heading. Products (Edit)------------ Tax --- Total 1 x Unreal Tournament 17.00% --- $22.32 The GST & HST portion of taxes are charged at the proper rate (5% and 7%) on both the product and shipping in the final totals Sub-Total:------------------$22.32 Flat Rate (Best Way):--------$5.00 HST portion class tax rate:--$1.91 GST class tax rate BC:-------$1.37 Total:-----------------------$30.60 Test case 2 is a Alberta purchaser.(checkout_confirmation.php page) It doesn't list the Tax and Total headings nor does it list the 5% tax that should have been charged. Products (Edit) 1 x Unreal Tournament---------------------------------$22.32 This results in no tax at all whereas it should be charged the GST 5% tax Sub-Total:------------------------------------------------------------------------------$22.32 Canada Post (1 box(es) to be shipped) (Expedited, 2011-02-22): $8.65 -----------------------------------------------------------------------------Total:--------$30.97 Test case 3 is a USA purchaser.(checkout_confirmation.php page) Basically it prints the same as test case 2 which is all right as no tax is to be charged. Can anyone tell me what I have done wrong or what I have to do to correct it? I don't really know php but i can alter the code as well as the next person. Regards Rick

Hi All Just installed OSC 2.3.1 plus the Canada Post shipping and Canada tax modules and am trying to work things out. I am in BC and have to charge taxes. A few strange things are happening which I will list later on but first here are my settings: Tax Zones Tax Zones British Columbia HST Country-------- Zone Canada ---------- British Columbia Tax Zones Canada GST Country-------- Zone Canada ---------- All Zones Tax Classes Tax Classes Non Taxable Goods Taxable Goods Tax Rates Priority ---- Tax Class---- Zone---- Tax Rate 2 --------- Taxable Goods ---- British Columbia HST---- 7.00% 2 --------- Taxable Goods ---- British Columbia HST ---- 5.00% 2 --------- Taxable Goods ---- Canada GST ------------- 5.00% All my products are given a Taxable Goods except "gift certificates" which are Non Taxable Goods. So all looks OK to me. I've set up 3 test purchases to test purchases from BC, other Canadian Provinces and the USA. Here's what happens: (dashes put in by me for readability) Test case 1 is a BC purchaser.(checkout_confirmation.php page) It shows 17% instead of 12% below the Tax heading. Products (Edit)------------ Tax --- Total 1 x Unreal Tournament 17.00% --- $22.32 The GST & HST portion of taxes are charged at the proper rate (5% and 7%) on both the product and shipping in the final totals Sub-Total:------------------$22.32 Flat Rate (Best Way):--------$5.00 HST portion class tax rate:--$1.91 GST class tax rate BC:-------$1.37 Total:-----------------------$30.60 Test case 2 is a Alberta purchaser.(checkout_confirmation.php page) It doesn't list the Tax and Total headings nor does it list the 5% tax that should have been charged. Products (Edit) 1 x Unreal Tournament---------------------------------$22.32 This results in no tax at all whereas it should be charged the GST 5% tax Sub-Total:------------------------------------------------------------------------------$22.32 Canada Post (1 box(es) to be shipped) (Expedited, 2011-02-22): $8.65 -----------------------------------------------------------------------------Total:--------$30.97 Test case 3 is a USA purchaser.(checkout_confirmation.php page) Basically it prints the same as test case 2 which is all right as no tax is to be charged. Can anyone tell me what I have done wrong or what I have to do to correct it? I don't really know php but i can alter the code as well as the next person. Regards Rick

Hi Ken 1./ Couldn't get on your site. It requires a logon/pswd? 2./ Which is the module to load that will handle the tax ? 3./ Is HST handled as a function of pst + gst? Rick

Sounds like 2 different modules are calculating the tax? I would guess that if you find the code in the shipping module that calculates tax and delete just that line your problem will be solved. I'm new to this so maybe someone else with more experience can weigh in here. Rick