Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Bill of Materials Question

23 REPLIES 23
Reply
Message 1 of 24
SteveFrey
608 Views, 23 Replies

Bill of Materials Question

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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
23 REPLIES 23
Message 2 of 24
japike
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 2022
Message 3 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 4 of 24
japike
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 2022
Message 5 of 24
SteveFrey
in reply to: japike

yes

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 6 of 24
bobvdd
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
Message 7 of 24
Rich.O.3d
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]
Message 8 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 9 of 24
Rich.O.3d
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]
Message 10 of 24
SteveFrey
in reply to: Rich.O.3d

Thanks.  I will check first thing in the morning.

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 11 of 24
SteveFrey
in reply to: Rich.O.3d

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

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 12 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 13 of 24
bobvdd
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
Message 14 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 15 of 24
bobvdd
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
Message 16 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 17 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 18 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 19 of 24
bobvdd
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
Message 20 of 24
SteveFrey
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 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report