SW BOM Restructuring
SW BOM Restructuring
(OP)
Hello World,
SW '05
SP 5
I have created a SW Assy BOM that, isn't Excel based composed of ruffly 70 components. Our MRP system BOM has gaps between the positions of these 70 components yielding a non-consecutive BOM e.g 1,2,3,6,7,8,12,13. This is caused from previous engineering changes.
Are there any suggestions on how I can skip positions on the SW Drawing BOM to reflect our MRP? Our MRP is not as friendly as some so I'm hoping there is a way of manipulating the SW Drawing BOM instead of resorting to modifying the MRP BOM. I thought of making "dummy" components as place holders but I don't want to deal with maintaining these dummy components in the future.
Thanks for your suggestions in advance,
Tom
SW '05
SP 5
I have created a SW Assy BOM that, isn't Excel based composed of ruffly 70 components. Our MRP system BOM has gaps between the positions of these 70 components yielding a non-consecutive BOM e.g 1,2,3,6,7,8,12,13. This is caused from previous engineering changes.
Are there any suggestions on how I can skip positions on the SW Drawing BOM to reflect our MRP? Our MRP is not as friendly as some so I'm hoping there is a way of manipulating the SW Drawing BOM instead of resorting to modifying the MRP BOM. I thought of making "dummy" components as place holders but I don't want to deal with maintaining these dummy components in the future.
Thanks for your suggestions in advance,
Tom
Failure is a prerequisite of successful design






RE: SW BOM Restructuring
Yet another case of the tail wagging the dog.
An MRP system is supposed to reflect the design of the product. When MRP starts to dictate product design it is past time to get a better system.
[/rant]
Sorry I don't have a simple, sensible, constructive answer for you. My answer is change the MRP system.
RE: SW BOM Restructuring
Failure is a prerequisite of successful design
RE: SW BOM Restructuring
Right now it looks like the plan is to just reorder the MRP based on the BOM that Solidworks generates.
BOM's that are still in Autocad will just stay with the empty item numbers until they get redrawn in Solidworks.
It will kinda be annoying but still will be better than having to make BOM's in the AUTOCAD drawing and in the MRP and still not having a guarantee that they match what will actually be built.
Can't wait till we switch.
RE: SW BOM Restructuring
We have created dummy parts called 00001A, 00002A, 00003A, 00004A, and etc. The description is the same for all parts ***DO NOT USE***
When we want to remove item 12 from the BOM and hold that place. We put in 00001A with a quantity of zero.
Bradley
SolidWorks Premim 2007 x64 SP4.0
PDM Works, Dell XPS Intel(R) Pentium(R) D CPU
3.00 GHz, 5 GB RAM, Virtual memory 12577 MB, nVidia 3400
RE: SW BOM Restructuring
Strikeoutoptions?RE: SW BOM Restructuring
I didn't think of that. I already invested in future long-term carpal tunnel with all the data editing to the MRP.
Thats good to know for next time though.
SW-FYI
"If components have been deleted from the assembly since the Bill of Materials was created, you can keep the components listed in the table. If missing components are still listed, the text for the items can appear with Strikeout display."
So I tried this out on an assy and provided an image for those curious.
For Item #3 I deleted it and inserted a different part.
For Item #4 I executed a Replace Components.
See attachment for image
Failure is a prerequisite of successful design
RE: SW BOM Restructuring
I just found this survey on the SW site concerning issues with BOM's and wanted to share with you folks.
http://w
Best,
Colin
Macduff![[spin] spin](https://www.tipmaster.com/images/spin.gif)
Colin Fitzpatrick
Mechanical Design Engineer
Solidworks 2007 SP 4.0
Dell 390 XP Pro SP 2
Intel 2 Duo Core, 2GB RAM
nVida Quadro FX 3450 512 MB
RE: SW BOM Restructuring
I am glad to see it on SolidWorks radar.
Cheers,
Anna Wood
SW 2007 SP4.0, WinXP
Dell Precision 380, Pentium D940, 4 Gigs RAM, FX3450
http://designsmarter.typepad.com/solidmuse
http://www.phxswug.com