BOM not merging part quantities.

[Garrett317]

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?

[StephenW · Accepted solution]

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.

[Garrett317]

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]

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.