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

Unable to generate Item numbering using startswith

edited Feb 11, 2024 1:29PM in Product Master Data Management 2 comments

Summary:

I am trying to generate item numbering using with String function "startswith" as shown below:

Primary IF Expression - startsWith("9", [Item].[Eng].[PART Number])

Secondary IF Expression: True

Return Value = "10000" + [Item].[Engineering].[PART Number]

(This part is working)

Secondary IF Expression: False

Return Value =auto_sequence("NonOSPartNumber", 10001000000, 1)

(This part is NOT working)

Implementing Product Management (23D) states that "Returns TRUE when look_in_string starts with look_for_string. Returns FALSE otherwise." Not sure why FALSE is not working.

Can anyone provide me pointer why this is not working?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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