Skip to Content
avatar image
Former Member

Need help with dependency

I am trying to write a dependency that looks at the customer number and then pulls a material into the production BOM (or not) depending on the customer number value.

If customer A and C have a branded part, then the branded part should be pulled into production BOM. If customer B does not have a branded part, then a generic part should be pulled into the production BOM.

There are dependencies on the branded parts (E_CUST = 'A', E_CUST = 'C') and those work fine. The dependency for the generic part is where I'm having a problem. I have written the dependency so that if E_CUST does not equal A or C, then use the generic part. Code is below. If I remove the "NOT" then the syntax is correct, but then the generic part is added even when the customer has a branded part. What is the correct syntax to make this work? "E_CUST" characteristic is single value.

E_CUST NOT IN ('A','C','D')
                                                                        
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 06 at 06:47 AM

    Hi Jamie,

    You could also try the following:

    NOT (E_CUST IN ('A', 'C', 'D'))

    Here the link to the documentation for the NOT operator:

    Dependency syntax - General rule

    Thanks and bye,

    Flavio

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02 at 09:37 PM

    You could try the following: E_CUST <> 'A' AND E_CUST <> 'C'

    Add comment
    10|10000 characters needed characters exceeded