How can I make sales tax follow customer province. I have setup customer card province ON - Ontario, use second tax - yes.
I have accountancy setup VAT account with rate 2 yes (type 1) according to different province, and the code is ON…
But sales order VAT will not follow customer province. It follow product GST rate. Can you tell me how to setup properly second tax rate follow customer province automatically.
Further more it should follow recipient (ship to) province. For example Amazon bill to is in USA. But we ship to ON and BC warehouses and use different sales tax 13% and 5%.
Please help. Thank you so much.
Maybe new version
With version 6.0, you can try to create several tax entries into home - setup - sales tax with a different code for each province.
But the user will have to choose the correct vat rate/code according to customer province.
1 Like
Thank you Eldy,
I have set up different sales tax, code for each province. I have VAT code match to customer location. For example customer address province QC. I have set up VAT QC. But it doesn’t link together. I found VAT rate can be changed after customer order has been entered while before creating invoice. But some sales order has 20 to 30 lines. If I ask my order entry colleague to change every sales order line by line, they will hit me with a baseball bat.
I tried and figured out a possible solution by using product selling price levels. Change basic set up without tax. Each product has levels of GST, HST, QST and other province tax levels. Assign customer with price level match to their province. Even though I already have 9 price tiers for each product, and I have almost 500 SKUs. But I think I can SQL mass upload 25000 lines into the database. However, the invoice will not show VAT. Customer will not understand and will not accept that. Also I don’t know how to record and summarize those tax in accountancy.
I think customer (ship to) location province should connect to VAT. Sale order read customer VAT first then see product is tax applicable or not. (no tax for food)
I hope the customer order can run this way. If it is my lack of knowledge of how to operate the system, please also guide me to the right direction.
Thank you very much.
1 Like
I’m in Ontario and while I can properly calculate HST, I can’t seem to find how to replace the default VAT labels with the HST labels. Any help would be most appreciated.
