×
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 Question

BOM Question

BOM Question

(OP)
I am using SW2007. Does anyone know how to overide the quantity in an excell based BOM and have SW retain the changes. We use materials in our assemblies, like solder and flux, that I would like to show up on our BOM as AR (As Required). I currently just save a blank part with our material part number and insert that into our assembly, so the quantity shows up as 1. Any help would be appreciated. Thanks.

RE: BOM Question

Tools – Options – Document Properties – Detailing – Bill of Materials "Uncheck" Automatic update of BOM

And then force revise the quantity in excel based BOM to A/R ( as required)

RE: BOM Question

reilly22,
Add these "AR" parts to the very top of your parts list where SW ends automatic parts count. At anytime, do not aggravate (sounds funny...bear with me…) the SW excel BOM by adding these "AR" to the beginning or inserting them anywhere (between parts) in the BOM. It will wipeout all your additions when it does an automatic update. But seems to stay put when your additions are added to the end of the BOM.

I hope I didn't confuse you.

Best,

Macduff spin
Colin Fitzpatrick
Mechanical Design Engineer
Solidworks 2007 SP 2.2
Dell 390 XP Pro SP 2
nVida Quadro FX 3450/4000



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