I would like to create a bill of materials where I can get the total length of each part used. In other words I have something called PART A and I might have 6 or 7 of them at different lengths. I want to get a total length of the material used. My parts list is showing each one listed as its own part with individual lengths. How do I convert this?
Yes. They all have the same part number. So items #3 and #4 would be combined. So would #13 and #14. See attached.
In your BOM there is a button called "Part Number Row Merge Settings" if you select that there should be a check box called "Enable Row Merge on Part Number Match". Is that checked?
Can you post a small subset assembly of your data that just contains items #3 and #4 and #13 and #14?
Or you can send it privately to me if you don't want to post publicly (email@example.com)?
something to check...
are you using susbstitution on the qty or unit qty columns in your part list?
have a look at the substition tab for them, do they show first value or sum of values in the 'when rows are merged....'
the unit qty one should sum them (or at least i seem to remember that it used to in earlier versions)
I'm not exactly sure. I will have to wait until I get into work tomorrow to answer this. in the meantime can you post a screenshot of this? Thanks.
Thanks. I will check first thing in the morning.
So I checked and it is not set with the check mark to substitute.
So I checked and my column is formatted differently. I tried to change it but I didn't have any luck. Should I be formatting the part column? I want to combine them into one single total.
What happens if you select the "Enable value substitution" option?
Does that not open up access to "Sum of values" in the dropdown just below on the right?
It does open up access to the sum of values drop down. I'm just not sure what to set it at.
You are supposed to enter a custom property or an iproperty that represents the length of your part.
Not sure of you have such a custom property.
Here is another approach. I tried to explain step by step. All steps are essential to make the summation work properly:
1. Open your PART A ipt file
2. In the Parameter dialog, rename the d* parameter of your part that represents its length to "length"
3. Assign a value to the stocknumber (don't leave it blank)
5. In the document settings of the part on the Bill of Materials tab, set the base qty = length
4. Modify your part to become an ipart and create a different member for each length
6. Insert ipart members in the assembly
7.Create a drawing view and parts list of your assembly
8. Edit the parts list
9. Use the Group settings button and check the group button and set your first key to Stocknumber
At this point your parts list should roll up on the stocknumber (if all your stocknumbers are identical) and the total length will be shown in the QTY column.
I can shoot a video for you if this looks all too complex.
I will try it step by step but a video would make it easier. It's wierd, some of my assemblies total everything and some of them list each one separatey. It must be set in the template that I originally created them with.
You said to put the ipart members into the assembly. Does it matter if these are parts, not iparts?
The other thing I did not mention is that they are all frame generator based parts. With this being the case would I need to set the parameter to "length" in the base part in the content center?
If these are framegenerator parts, it is so much simpler. Wish you had mentioned that in the first place. :-(
You don't need iparts and you don't need to change parameters or set document settings. A framegenerator part is already set up in the right way to allow parts list roll-up on the QTY column.
The only thing to do is step 9 (Group your QTY column on the stocknumber) and your parts list should be fine.
Okay. What you're saying makes sense but its not working. Hmmm. What could I be doing wrong?
Search the Autodesk Knowledge Network for more content.
New: Get an Activation Code
Mac OS X 10.12 Support
Windows 10 Support
Autodesk Online Store Help
Serial Numbers & Product Keys
Installation & Licensing
Online Activation & Registration
Network License Administration
Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.