Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
Post 1 of 24

Bill of Materials Question

427 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
322 Posts
95 Kudos
Registered: ‎02-06-2004
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
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
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 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
322 Posts
95 Kudos
Registered: ‎02-06-2004
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
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
Post 5 of 24

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
578 Posts
47 Kudos
Registered: ‎11-23-2005
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

Valued Mentor
526 Posts
65 Kudos
Registered: ‎08-19-2008
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]
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
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 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
526 Posts
65 Kudos
Registered: ‎08-19-2008
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]
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
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 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!