Flat Bill of Material

Forum|Forum|9 years ago
August 22, 2016
3 replies
5268 views

I have realized that Creo is not the most user friendly when trying to export a BOM to excel. I have saved my BOM to a .txt document and am opening that in excel and it works really well. The only problem that I have is that it separates all the subassemblies and breaks each down into its components and doesn't give me the total number contained of each part in the assembly. I have read that there may be a way to get a FLAT BOM instead of a RECURSIVE BOM which I believe I have. I just don't know how to get there. Is there anyone that has worked with this?

Your help is very much appreciated.

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

2D Drawing

M

MikeLockwood

22-Sapphire I

If not using Windchill, then have to rely on "BOM" tools in Creo.

If using Windchill and WTParts, then those tools are best by far.

If using Windchill for CAD Only, can use the tools under the Assembly Structure tab - reports of various kinds.

K

ktenhaken

Author

1-Visitor

So there is no way for it to read out the total number of each part contained in the assembly without Windchill? Sounds like that is something that they should get working on.

M

MikeLockwood

22-Sapphire I

Absolutely. Model, Bill of Material or Tools, Bill of Material. Result is web page. Select to save to a file (standalone web page). Can convert to Excel from there if needed.