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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

BOM not merging part quantities.

Garrett317
8-Gravel

BOM not merging part quantities.

I have two parts (call them Part 1 and Part 2) within my BOM that are used in two different positions in the assembly. My BOM calls out Part 1 and Part 2 twice:

 

QTY       PART

1            Part 1

1            Part 1

1            Part 2

1            Part 2

 

How can I merge the rows together so that there is one row for Part 1 and another for Part 2, each having a quantity of 2?

 

QTY       PART

2            Part 1

2            Part 2

 

Could this be fixed using the repeat region?

 

1 ACCEPTED SOLUTION

Accepted Solutions
StephenW
23-Emerald II
(To:Garrett317)

Go to table - repeat region - attributes and select No dup/level.

 

If you are using flexible components, these have historically been a problem for repeat regions.

View solution in original post

3 REPLIES 3
StephenW
23-Emerald II
(To:Garrett317)

Go to table - repeat region - attributes and select No dup/level.

 

If you are using flexible components, these have historically been a problem for repeat regions.

Thank you, that worked great. However, the index numbers changed. It used to be:

 

INDEX     QTY     PART

   1              1        Part 1

   2              1       Part 1

   3              1       Part 2

   4              1       Part 2

 

After merge:

INDEX     QTY     PART

   5              2        Part 1

   6              2       Part 2

 

How do I change the index values to:

INDEX     QTY     PART

   1              2        Part 1

   2              2       Part 2

 

StephenW
23-Emerald II
(To:Garrett317)

Had you already used fix index? If so, you'll need to unfix 1-4 or maybe unfix the region, depending on how you fixed the index.
Top Tags