BOM Editor - Assembly Number vs Single Part Number

BOM Editor - Assembly Number vs Single Part Number

Flies-Eyes
Advisor Advisor
847 Views
8 Replies
Message 1 of 9

BOM Editor - Assembly Number vs Single Part Number

Flies-Eyes
Advisor
Advisor

I am looking to create a output list that uses Assembly Number for objects in a welded group and the Single part numbers for sandalone objects like purlins and loose beams welded on side.

 

Is there a way to create that list in the BOM Editor? 

0 Likes
848 Views
8 Replies
Replies (8)
Message 2 of 9

Julio_Soto
Advisor
Advisor

can you screenshot an example of what the final output looks like?  Right off the top of my head, yes this is possible. That's how we do it where I am at.

Message 3 of 9

Flies-Eyes
Advisor
Advisor

At the moment I am looking trying to write a if statement in the BOM Editor to say if the object is class Standalone, then use the Single Part number, if not then use the Assembly Number. 

 

FliesEyes_0-1713047708930.png

 

0 Likes
Message 4 of 9

Flies-Eyes
Advisor
Advisor

This string is my first attempt but not joy:-

 

=|Class="Standalone" ? |NUM : ../MNum

0 Likes
Message 5 of 9

Flies-Eyes
Advisor
Advisor

Secound attempt no joy...

 

=|Class="Standalone" ? |Num : |MNum

0 Likes
Message 6 of 9

Flies-Eyes
Advisor
Advisor

Sorry, my fat fingers hit the accept as a solution button.

 

Third attempt at least came close.  The '|' is different to 'I'.... 

This string is just using singlepart number but not using Assembly Number yet.

 

 

=IClass="Standalone" ? INum : IMNum

Message 7 of 9

Julio_Soto
Advisor
Advisor

how you tried the post numbering method Assembly Number = Single Part number? (something like that)

 

0 Likes
Message 8 of 9

Flies-Eyes
Advisor
Advisor

Winner winner chicken dinner....

 

I don't need a script at all, just the right syntax.  IPNum is the correct code.

 

FliesEyes_0-1713049322080.png

 

0 Likes
Message 9 of 9

Flies-Eyes
Advisor
Advisor

ooooppps....  might have called it too soon....  it is close but I am not getting the desired output just yet.

 

I am not sure what it is doing so I will need to do some digging.

 

0 Likes