Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.

Inventor Forum

Reply
Highlighted
Post 1 of 24

Bill of Materials Question

488 Views, 23 Replies
04-27-2012 10:30 AM

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?

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 2 of 24

Re: Bill of Materials Question

04-27-2012 10:36 AM in reply to: SteveFrey

Can you give all of them the same part number so that they combine on your parts list?

Peace,
Jeff
Inventor 2013
Post 3 of 24

Re: Bill of Materials Question

04-27-2012 10:42 AM in reply to: japike

Yes.  They all have the same part number.  So items #3 and #4 would be combined.  So would #13 and #14.  See attached.

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 4 of 24

Re: Bill of Materials Question

04-27-2012 10:56 AM in reply to: SteveFrey

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?

Peace,
Jeff
Inventor 2013
Post 5 of 24

Re: Bill of Materials Question

04-27-2012 11:18 AM in reply to: japike

yes

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 6 of 24

Re: Bill of Materials Question

04-27-2012 04:24 PM in reply to: SteveFrey

Steve,

 

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 (bob.van.der.donck@autodesk.com)?

 

Thanks.

Bob




Bob Van der Donck


Principal UX designer DMG group
Post 7 of 24

Re: Bill of Materials Question

04-29-2012 05:51 PM in reply to: bobvdd

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)

CAD Management 101:
You can do it your own way,
If its done just how I say!
[Metallica:And Justice For All:1988]
Post 8 of 24

Re: Bill of Materials Question

04-29-2012 06:53 PM in reply to: Rich.O.3d

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.

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 9 of 24

Re: Bill of Materials Question

04-29-2012 07:39 PM in reply to: SteveFrey

see attachment

CAD Management 101:
You can do it your own way,
If its done just how I say!
[Metallica:And Justice For All:1988]
Post 10 of 24

Re: Bill of Materials Question

04-29-2012 07:45 PM in reply to: Rich.O.3d

Thanks.  I will check first thing in the morning.

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 11 of 24

Re: Bill of Materials Question

04-30-2012 07:00 AM in reply to: Rich.O.3d

So I checked and it is not set with the check mark to substitute.

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 12 of 24

Re: Bill of Materials Question

05-01-2012 09:31 AM in reply to: Rich.O.3d

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.   

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 13 of 24

Re: Bill of Materials Question

05-01-2012 10:11 AM in reply to: SteveFrey

Steve,


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? 

 

Bob




Bob Van der Donck


Principal UX designer DMG group
Post 14 of 24

Re: Bill of Materials Question

05-01-2012 10:36 AM in reply to: bobvdd

It does open up access to the sum of values drop down.  I'm just not sure what to set it at.

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 15 of 24

Re: Bill of Materials Question

05-01-2012 12:06 PM in reply to: SteveFrey

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.

 

Bob




Bob Van der Donck


Principal UX designer DMG group
Post 16 of 24

Re: Bill of Materials Question

05-01-2012 12:10 PM in reply to: bobvdd

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.

 

Thanks,

 

Steve

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 17 of 24

Re: Bill of Materials Question

05-01-2012 01:03 PM in reply to: bobvdd

You said to put the ipart members into the assembly.  Does it matter if these are parts, not iparts?

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 18 of 24

Re: Bill of Materials Question

05-01-2012 01:07 PM in reply to: bobvdd

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?

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post 19 of 24

Re: Bill of Materials Question

05-01-2012 01:28 PM in reply to: SteveFrey

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.

 

Bob




Bob Van der Donck


Principal UX designer DMG group
Post 20 of 24

Re: Bill of Materials Question

05-01-2012 01:48 PM in reply to: bobvdd

Okay.  What you're saying makes sense but its not working.  Hmmm.   What could I be doing wrong?

Steve Frey
Inventor 2015
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post

Inventor Exchange Apps

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.