Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
SteveFrey
Posts: 519
Registered: ‎09-12-2007
Message 1 of 24 (416 Views)

Bill of Materials Question

416 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 2013
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
Valued Mentor
japike
Posts: 322
Registered: ‎02-06-2004
Message 2 of 24 (402 Views)

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
Distinguished Contributor
SteveFrey
Posts: 519
Registered: ‎09-12-2007
Message 3 of 24 (405 Views)

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 2013
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
Valued Mentor
japike
Posts: 322
Registered: ‎02-06-2004
Message 4 of 24 (397 Views)

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
Distinguished Contributor
SteveFrey
Posts: 519
Registered: ‎09-12-2007
Message 5 of 24 (388 Views)

Re: Bill of Materials Question

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

yes

Steve Frey
Inventor 2013
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
Product Support
bobvdd
Posts: 552
Registered: ‎11-23-2005
Message 6 of 24 (356 Views)

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

Valued Mentor
Rich.O.3d
Posts: 525
Registered: ‎08-19-2008
Message 7 of 24 (329 Views)

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]
Distinguished Contributor
SteveFrey
Posts: 519
Registered: ‎09-12-2007
Message 8 of 24 (324 Views)

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 2013
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
Valued Mentor
Rich.O.3d
Posts: 525
Registered: ‎08-19-2008
Message 9 of 24 (324 Views)

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]
Distinguished Contributor
SteveFrey
Posts: 519
Registered: ‎09-12-2007
Message 10 of 24 (313 Views)

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 2013
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
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.