Inventor General

Reply
Distinguished Contributor
Posts: 495
Registered: ‎09-12-2007
Message 1 of 24 (402 Views)

Bill of Materials Question

402 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 (388 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
Posts: 495
Registered: ‎09-12-2007
Message 3 of 24 (391 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 (383 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
Posts: 495
Registered: ‎09-12-2007
Message 5 of 24 (374 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
Posts: 523
Registered: ‎11-23-2005
Message 6 of 24 (342 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: 509
Registered: ‎08-19-2008
Message 7 of 24 (315 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
Posts: 495
Registered: ‎09-12-2007
Message 8 of 24 (310 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: 509
Registered: ‎08-19-2008
Message 9 of 24 (310 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
Posts: 495
Registered: ‎09-12-2007
Message 10 of 24 (299 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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


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.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube