Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
Hello,
I have come across this issue several times and I am not sure if there is a way to resolve it. Basically, the issue is we use our part's name as the part number column in our BOM table. With objects such as fasteners, it is common to show a few within the assembly to give a pictorial assembly image on the drawing and populate the rest of the quantity with bulk items. Could you merge the items together within a BOM repeat region to give the correct qty.
Ex.
C-800500-001 → 1/4-20 Bolt
C-800500-BULK→ Bulk Item for 1/4-20 Bolt
within the table
Item Qty Part Number
1 5 C-800500-001
2 995 C-800500-BULK
Merge
Item Qty Part Number
1 1000 C-800500-001
Use a relation in the part files themselves that changes the field value.
BOM_PartNumber = extract(rel_model_name,1,8)
If your model name is C-800-500-BULK, then BOM_PartNumber will be C-800500.
If that doesn't work, then change the name to BOM_PartNumber = extract(rel_model_name,1,8)+'-001' which will give C-800500-001.
Lots of options to manipulate the data for what you need.
This is one example of why using a relation to build a BOM-PartNumber in your start part can save time later. By using a system variable, you get locked in too much.