Share
ReportHi everyone,
We're a canadian cie who's selling all over canada. Since some of our client are from elsewhere in Canada and taxes are provincial, we set them with a tax schedule that fit there province. Items are set with our provincial taxation. Over that, some of our items are only taxable on a federal level. To fit our need, we have 2 declinations of the 5% federal tax : the stadard TPS (federal 5% tax) and TPSH (federal 5% tax when used in a tax schedule for customers from other canadian provinces). The TPS and TPSH are not going in the same account GL wise and are displayed separately on the invoice.
My problem : I'm trying to invoice a customer from another province with shipping fees. The customer is set with a tax schedule which include the taxation from the province and the TPSH (since out of our province) but the item they bought is taxable with TPS ... so my item and Customer share no taxation
Illustration :
Customer (TPSH + TVH-OTHERPROVINCE = 13% in account 215)
Item (TPS = 5% in account 210)
Bought : 119,70 $ + 6,00 shipping = 125,70$
Taxes should be applied as below :
119,70$ * TPS = 5,99$ TPS
6,00 * TPSH + TVH-OTHERPROVINCE = 0,78 $
With our actual setting, we're only getting the shipping taxes (0,78 $) on the invoice.
I suppose my problem should be resolved by a simple "tweek" but I didn't found it yet.
I'm still hoping I miss understood Leslie Vail intervention in the following post https://community.dynamics.com/gp/f/32/t/137861. If I understand correctly, this will never work since the taxes from the item and the customer are totally different.
We're using GP 2013 R2.
All hint would be appreciated.
Kind regards,
Olivier
*This post is locked for comments
All responses (
Answers (
28,058
