Can you lock down a BOM?
Can you lock down a BOM?
(OP)
We are currently using SW2004, SP4.1 and I have the following problem. I did not check this in SW2005 to see if they have fixed this...
In a SW drawings, I have a BOM. When it comes in, it comes in ordered from the feature tree. Lets say I have 5 BOM items. Item one is a manifold. After I do the drawing, I have to go back and use SW Explorer to rename this item. When I open the drawing, the BOM order is changed and now, my number 1 item, Manifold, is now number 5 as all the others have moved down.
I need for the BOM to be locked once it is inserted. Is this possible or is this an enhancement request? If I have notes, one might say to clear anodize item 1. I like the way SW updated the balloons to match since they re-ordered the BOM but it does nothing for a standard notes.
In a SW drawings, I have a BOM. When it comes in, it comes in ordered from the feature tree. Lets say I have 5 BOM items. Item one is a manifold. After I do the drawing, I have to go back and use SW Explorer to rename this item. When I open the drawing, the BOM order is changed and now, my number 1 item, Manifold, is now number 5 as all the others have moved down.
I need for the BOM to be locked once it is inserted. Is this possible or is this an enhancement request? If I have notes, one might say to clear anodize item 1. I like the way SW updated the balloons to match since they re-ordered the BOM but it does nothing for a standard notes.






RE: Can you lock down a BOM?
You can turn BOM update off.
As a side question. Why do you have to rename your item? I assume you are talking about description and not the file name.
Bradley
RE: Can you lock down a BOM?
Hope that helps explain why I want to lock it from changing item numbers
RE: Can you lock down a BOM?
If I turn off the BOM update, will it update the part number that I changed in SW Explorer as previouly described?
RE: Can you lock down a BOM?
Excel is RMB > Properties > Control > Row numbers follow assembly ordering
SW BOM is click on top of BOM to open BOM Manager at side of screen Follow assembly order.
RE: Can you lock down a BOM?
RE: Can you lock down a BOM?
I do not know if your part number will update. I never use SW Explorer, but I believe your Excel BOM will not update.
I completely forgot about CorBlimeyLimey solution.
Good idea, CorBlimeyLimey.
Bradley
RE: Can you lock down a BOM?
I had tried that and that didn't work. I just now retried it and it still doesn't work. My VAR called and said that it doesn't work in SW2004, 4.2 either but in SW2005, it works.
Not sure why it didn't work with that command but I had tried it.
We might have to refence part numbers or descriptions rather than item numbers just to cover ourselves.
- Thanks!!
RE: Can you lock down a BOM?
This is an old habit from the beginning for us. What we do is, have all drawings, models and assemblies open. Then rename the files with a “Save As”. Our BOM update is turned on all the time for everyone. We have to use formulas in the quantity column. Items never move in our model tree unless we move them manually.
Good luck.
Bradley
RE: Can you lock down a BOM?
Thanks for the insight on how you guys do business. I am shocked about using formulas for the quantity, ours always updates automatically when you add or delete something. It even works with patterns so we don't worry.
I tried unchecking the update BOM and it works as far as not changing the order but it did not update the part number which is something we would need for it to do.
Thanks for your suggestion, I forgot about the check box for that also
RE: Can you lock down a BOM?
We use items that get other values beside EACH. Oil, glue, tape, tubing is feet, and others. We have to play a lot of tricks to get this done. We add a property to the model and a formula to excel. The formula is:
=IF(H3="EA",B3,IF(H3="FT",TEXT(I3/12,".0 FT"),IF(H3="NA",TEXT(,"0"),IF(H3="QTY",TEXT(J3,"0"),IF(H3="%",TEXT(J3,".00"),B3)))))
Bradley
RE: Can you lock down a BOM?
Both work fine in SW2004 SP2.1