Skip to Content
0

Need help with dependency

Feb 02 at 08:22 PM

53

avatar image
Former Member

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')
                                                                        
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

flavio ciotola Feb 06 at 06:47 AM
2

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

Share
10 |10000 characters needed characters left characters exceeded
Angela Scott Feb 02 at 09:37 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded