How to upload the geography hierarchy as value in Manage tax rules spreadsheet
in Tax & Global
We have created 'Manage Tax Condition Sets' and the determinant factor is 'Geography'. We have the condition based on county and city in United States. The issue is, when I create the condition set manually, system shows me hierarchy against which I can choose the actual value. See the screenshot below. I can ensure that 'Delaware' county I pick belongs to the state I need to choose.
However, the issue is, when I use Manage Tax Rules spreadsheet, It allows me to put value only as below. I can not put value as hierarchy 'Delaware.IA.United States'. When I upload using just Delaware, system takes the 1st one appearing in list of values, making my rules go completely wrong.
Tagged:
0