×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

BOM

BOM

(OP)
is there a way to change the default item numbers in the bom(with out maunual typing it in). example- instead of starting with item "1" would like to change it to start with "200", "300". We are doing large
machines & for detailing we have multiple people detail different sections, so it wouild be nice on each section to not always start from "1".

thanks

RE: BOM

1. Create new BOM Template. Hide the Item# column (this is a required column and cannot be deleted.) Insert your own custom column called something like "ItemNUM" or "Item". Do not use "Itemno" because that is the name of the original SolidWorks column. The text in the Header can say whatever you want. See more detail in the Help for "bill of materials: custom properties".

2. Add the new Custom File Property ("ItemNUM" or "Item") to every part in existing assemblies.

3. For New projects: Add the Custom File Property ("ItemNUM" or "item") to your Part Template. See help for "document template."

4. Step 2 above means you will no longer get automatic balloon numbering anymore. Balloon number is tied to the original "Itemno" column, which apperently you don’t want, because that number can often change. Instead, perform all ballooning using only custom text. That is, use split circle balloons with custom text above (where you manually type item) and custom text below (where you manually type sheet).

This method has the advantage that you have absolute control over your file property "Item" So you can maunally change your numbers if for some reason an overlap in numbers accidentally takes place between designers.

Hope this helps,

Anyone have any better ideas?????

Regards,
Jon

RE: BOM

Oh, one thing I forgot to mention is that instead of manually typing in the item numbers you can enter the first one, say "300" and use the excel functionality to drag it down the column and it should increment by 1's automaticaly.  if you want higher increments you can write a formula in the cell below the first value and have it  like =SUM (g1+10).  then you can drag that formula down the column for as many cells as you need and it will populate the cells in that increment.

hope that helps.

Regards,
Jon
jgbena@yahoo.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources