I have the following issue w.r.t setting up input taxes in Canada and I am looking for some help.
I have already researched a lot in the forums/threads and my situation is unique so please do not critise saying I should look through the existing threads as I have already done that.
I am suppose to configure Input (A/P) tax codes for Canada for the following providences and the rates are also undermentioned.
5.00 %9.98 %
Prince Edward Island
Following are the tax codes that I configured:
GJ A/P, GST applicable, PST exempt
HJ Input Tax HST Only
IJ A/P, GST applicable, PST applicable
PJ A/P, GST exempt, PST applicable
SJ A/P, Self assess GST and PST
The way I have configured these in the system is that since GST is federal tax, I have put the following percentages :
CA00: 5 % ( Since this is configured at federal level so it appears for both GJ, IJ )
Eg: CAYK: This gets its GST value from CA00 ( which is correct) ( VST: 5 %)
Eg: CABC: VST: 5 % (GST) and NVV 7 % (PST)
Eg: CAON: Since this has only HST taxes, I configured 13 % Flat for Acc Key VSH
Now the problem that I am facing is that if user selects the correct tax code for the above providences, its all good BUT if a user selects tax code GJ by mistake for Ontario instead of HJ, it gets 5 % because GJ is set up at federal level which is incorrect because for Ontario there is only HST taxes.
Similarly if a user selects a tax code for example IJ for New Brunswick ( CANB), system gets 5 % tax rate but it shouldn’t because CANB has only HST taxes. But because CA00 is set up as 5 % , system retrieves that rate for these region as well.
Please help me with your expertise with the solution for the above issue wherein I am trying to figure out how to either configure the system in a way that it gives me error if a user selects a wrong tax code for a given providence or if it is possible to restrict users to only select the correct tax code for these jurisdictions
I really appreciate your time and help.