AnsweredAssumed Answered

Need to make BOM PartNo = PART NUMBER if PartNo is blank

Question asked by Julian Dowden on Mar 22, 2013

I'm trying to utilize the Route Wire Library to convey a part number to our standard BOM table.  Regular parts in the harness assembly (connectors) show up in the 'Part No' column.  Wires from the Librarry show up in the 'Part Number' column.    I want everything to show up in the 'PartNo' column.

 

 

I've managed to make the wire QTY = AR by adding a property of QTY in each wire and specifying a value of Override_QTY...And then an overall property of Override_Qty with a value of AR.  And then adding the equasion IF(`Override_Qty`<>"";`Override_Qty`;'QTY') to the QTY BOM column.   I've been trying to get something like this to work for the part number issue.  But I'm coming up empty.

 

Please help!

 

 

Julian

Outcomes