Rename Qty Column in the new BOM
Rename Qty Column in the new BOM
(OP)
I am testing SolidWorks 2004 SP 2.1 and I am still seeing that I can't permanently rename the Qty Column in the new SWX BOM. I can rename it so the Config name/Qty is temporarily not displayed, but as soon as the drawing file is completely rebuilt (cntrl Q) the Column name in the BOM reverts right back to how it is out of the box with the addittion of the config name. Am I missing anything? Have I used the correct process to rename? I thought 2.1 was supposed to fix this if it is a bug. Is it still a limitation? The new BOM has frustrated me so far. It has so much promise, but things just weren't cleaned up from the beginning. Maybe I'm just doing something wrong. Any info would be great.
Pete Yodis
Harold Beck and Sons
Pete Yodis
Harold Beck and Sons






RE: Rename Qty Column in the new BOM
I thought this was working fine, until today.
I fixed our templates (which wouldn't previously save the change, but now do)and set them up using the Default config. Maybe the BOM needs to be based off of the same config the template was created from?
Either way, it still needs work.
RE: Rename Qty Column in the new BOM
RE: Rename Qty Column in the new BOM
Regards,
Scott Baugh, CSWP

http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
RE: Rename Qty Column in the new BOM
Is there any way to change the quantity displayed to "AR" (as required) in the excel BOM?
RE: Rename Qty Column in the new BOM
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=U...
You could get your BOM to look exactly as you want as follows:
1. Edit your BOM template (in excel)
2. add two columns immediately to the right of the "qty" column
3. put "AR" and "QTY" as headings for the new columns (I assume these will
be columns C & D respectively)
4. in the (new) "QTY" column (column D), put an excel formula that points to
the "AR" column if there is any text there, i.e. =IF(ISBLANK(C2),B2,C2).
Copy the formula down from D2 to D200 (or whatever the biggest BOM you
anticipate is)
5. hide the original "qty" column and the "AR" columns (columns B & C)
6. in any part you want listed with quantity "AR", create a custom property
called "AR", and put the text "AR" into that property.
Hope all that make sense.
good luck
Michael
This is from many years ago. There maybe a new solution out there from somebody else....Anybody else have a solution for this?
Regards,
Scott Baugh, CSWP

http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
RE: Rename Qty Column in the new BOM
RE: Rename Qty Column in the new BOM
RE: Rename Qty Column in the new BOM
I am not sure If I understand your question correctly, but if I do then this functionality would appear to be fine SP2.1
I remove "QTY" from the cells altogether, I renamed my QTY columns in the Solidworks 2004 type BOM from lets say "CS4-30772-001/QTY" to "-001" and this change stays in place no matter what I am doing to the assembly file, or the drawing file. Changing configs, adding configs, deleting configs, control Q and so on, the bom change stays intact. I would have to say that something else is the issue.
I do not think that using a defualt config is the problem, because I use whatever config I like and it still works for me.
The only known issue with the new bom's I believe, is with balloons, no matter what bom type is used "Top Level Only", "Parts Only" "Indented Assemblies", the balloon item numbers will always return to reflecting the "Top Level Type". Other than that everything seems to work fine, I use it all the time, I just have to use custom balloon callouts until they fix the issue.
John Cole
Sr Mechanical Engineer
Impco Technologies, Inc.
RE: Rename Qty Column in the new BOM
Pete Yodis
Harold Beck and Sons