Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. 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.