AnsweredAssumed Answered

How do I make an subassembly quantites on an indented bom match assembly quantities instead of being "quantity per" assembly?

Question asked by Bryan Harrington on Jan 21, 2016

right now our BOM looks like this:

 

posqty
15
1.11
1.22
1.33
26
2.12
2.22
2.33

 

I need the subassembly quantities to be multiplied to the top level assembly quantities to look as shown below:

we usually have to do this manually in excel, and it is very time consuming, and errors are made regularly. it drives our shop crazy. I know the above is more "industry standard" but our company does it like the way shown below because of our nesting programmers. so if anyone has an excel formula, or a macro, and can tell me how to use it, or insert it that would help tremendously!!

thanks.

posqty
15
1.15
1.210
1.315
26
2.112
2.212
2.3

18

Outcomes