on 02-02-2018 8:22 PM
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')
You could try the following: E_CUST <> 'A' AND E_CUST <> 'C'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
9 | |
6 | |
6 | |
5 | |
5 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.