Skip to main content
1-Visitor
November 18, 2020
Question

BOM Qty w/ Nested Repeat Region

  • November 18, 2020
  • 1 reply
  • 4756 views

Hopefully you guys can help, because I'm sure there is an easier way than we are doing this.

We have assemblies that ship along with bagged up extra hardware. In a lot of cases we also call out hardware that will be required but we are not providing. This has been an annoying task for us, but we have been successful in most regards. The main issue lies when the same hardware is used in the assembly and also is shipped loose.

Currently we create one BOM that lists the parts/hardware that is assembled in the shop. We then place a separate BOM for each ship loose pack on the next sheet, filter out all shop assembled items, and flatten this pack.

swood_0-1605737050020.png

This works unless some of this hardware is also in the top level, because it then merges with it and will not appear in this BOM. The BOM above represents (16) assemblies of a nut, screw, lock, and (2) flat washers. These all get thrown in a bag with a label for shipping.

 

What I would like to do is created a Nested Repeat Region that filters the BOM for only items with "~~~" in the description (that's how we designate items that aren't assembled) and then be able to show the total quantity of items that are going in each bag.

 

I've accomplished all of this except the total quantity. What I have is the quantity of the assembly and then of each item in that assembly. Although it is technically right, it isn't what we need.

swood_1-1605737258868.png

Is there a Repeat Region relation that I can use to tell it to multiple all part quantities by the assembly quantity and list that in a new parameter that I will assign to that column? (part.qty * asm.qty = total.qty)

We've done this for multiplying an entire BOM's quantity by a set number, but not for multiplying a part by its parent's quantity.

 

Thanks.

1 reply

swood1-VisitorAuthor
1-Visitor
November 23, 2020

It looks like no one has any idea how to multiply the quantities based on parent quantities

Does anyone know of a better way to do this in general?

Is there not enough information or is my original post confusing?

 

I appreciate any feedback I can get.

1-Visitor
December 2, 2020

I personally didn't really understand what you meant, a dummy assembly & model tree might help.

If I understood that correctly you flag the components as:

-assembled in the shop

-shipped loose

-extra hardware

 

Do you flag them using parameters?

And what do you mean by "This works unless some of this hardware is also in the top level, because it then merges with it and will not appear in this BOM"?

 

 

swood1-VisitorAuthor
1-Visitor
December 7, 2020

Thank you, again. Simplified Reps probably could be used, but like you said, that doesn't allow us to balloon where they will be installed at, and would require us to add view specifically for that. The drawings we are working on are already 20+ pages, and we don't want to make them any larger since they are difficult to work with.

When I mentioned "flattened", I was referring to flattening the BOM (the flatten/recursive option) so that we could see the parts in the sub-assembly, since we make subs of our hardware stacks.

 

I've found a lot of "close" answers, but nothing that gives us the functionality we need. I'll try to make up a small sample assembly to share in hopes that it clarifies things and maybe some others will chime in as well.