cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Can you merge part quantities in a repeat region.

ccates
1-Newbie

Can you merge part quantities in a repeat region.

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


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
1 REPLY 1
BenLoosli
23-Emerald II
(To:ccates)

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.

Top Tags