Tax condition set to check if Line Account start or contains a string value?
in Tax & Global
Summary:
We have a requirement to default a specific tax rate code if PRODUCT segment on the invoice distribution line starts with a certain prefix (for e.g. if PRODUCT segment = 'ESHC0001', then tax rule should work).
Our Product segment consists of 4 alphabets and a numeric code, and is not sequential in nature. I already tried below variations in defining a tax condition set, and none of them seem to work.
- PRODUCT Contains ESHC
- PRODUCT Starts with ESHC
- PRODUCT Contains 'ESHC'
- PRODUCT Starts with 'ESHC'
- PRODUCT Contains "ESHC"
- PRODUCT Starts with "ESHC"
Since the value set values for Product are not sequential, we cannot try operators like 'between' or 'greater then' also.
0