BOM problems
BOM problems
(OP)
I have tryed to adjust BOM for one of the company that intedet to use S.W. in the future.
They have standard that main assembly drawing is on first sheet of paper and the BOM is on second paper. So I run it some problem's;
1. How to put BOM on sheet other than source drawing ? I can put drawing in second sheet outside paper border, or just hide it, but that is kind slopy ...
2. Company's template for BOM is across whole page with fixed number of rows. Unused rows stay's empty. SolidWorks make BOM table only with rows that are needed, and so table is lower than I need. How do I make him to always build BOM with f.e. 20 row's (some used, some empty) ?
3. It seems that grid formating from excell (grid line's thicknes) is not visible in S.W. BOM, while font formating is ok ?
4. Size of BOM in Excell template and that BOM within SW are diffrent. In SW I get smaller BOM table (about 20% smaller)
5. .. because of that I can't format the rest of company's template of BOM (other notes and tables that Excell template for BOM doesn't inculde)
Software is SW 2001 (SP 0)
Maybe there is some good replacement for standard BOM command in SW that would be better for this solution ?
Tnx for any response...
They have standard that main assembly drawing is on first sheet of paper and the BOM is on second paper. So I run it some problem's;
1. How to put BOM on sheet other than source drawing ? I can put drawing in second sheet outside paper border, or just hide it, but that is kind slopy ...
2. Company's template for BOM is across whole page with fixed number of rows. Unused rows stay's empty. SolidWorks make BOM table only with rows that are needed, and so table is lower than I need. How do I make him to always build BOM with f.e. 20 row's (some used, some empty) ?
3. It seems that grid formating from excell (grid line's thicknes) is not visible in S.W. BOM, while font formating is ok ?
4. Size of BOM in Excell template and that BOM within SW are diffrent. In SW I get smaller BOM table (about 20% smaller)
5. .. because of that I can't format the rest of company's template of BOM (other notes and tables that Excell template for BOM doesn't inculde)
Software is SW 2001 (SP 0)
Maybe there is some good replacement for standard BOM command in SW that would be better for this solution ?
Tnx for any response...






RE: BOM problems
2.cant do number 2 the software allocates rows per part ive never found a way round this
3.the excell spreadsheet gets the information to format from the assembly template. so if you have 6 point high letters in the spreadsheet in excell it will default to whatever the assembly or drawing properties are set to
4.generally same as above
RE: BOM problems
To show the BOM on sheet 2, insert sheet 2, stick in any old view, insert the BOM referenced to the view on sheet 2, then hide the view. The BOM is still there. This is not "slopy", it is technology.
I have no problem showing blank lines in a BOM. Just edit the BOM and insert how ever many lines you need and they will show up. You can type whatever you want in this part of the document. In fact, you may need to type a placeholder. A period or a space or a non-printing ASCII character should do it.
There is no reason the "size" of the spreadsheet in SW drawings should match what you see on the screen. You just need to set the column widths to suit what will show on a particular drawing format size. That means you will have a template or a macro for each paper size. The BOM feature sizes the sheet to whatever text is displayed when it first generates to the drawing sheet.
Crashj 'Lost In [paper] Space' Johnson
RE: BOM problems
Tnx...
RE: BOM problems
RE: BOM problems
Item Qty Number Description
1 1 A00001 Do not use
This way we make no changes to our BOM template.
Bradley