You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Tax condition set to check if Line Account start or contains a string value?

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!