Skip to main content
G
Garrett3171-Visitor
1-Visitor
September 12, 2018
Solved

BOM not merging part quantities.

  • September 12, 2018
  • 1 reply
  • 3916 views

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?

 

Best answer by StephenW

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.

1 reply

S
23-Emerald III
StephenW23-Emerald IIIAnswer
23-Emerald III
September 12, 2018

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.

    G
    Garrett3171-VisitorAuthor
    1-Visitor
    September 12, 2018

    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

     

    S
    23-Emerald III
    StephenW23-Emerald III
    23-Emerald III
    September 12, 2018
    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.
    Terms & ConditionsCookie settingsAccessibility statement