MicroStation Forum - Parts List / BOM
BMPCreated with Sketch.BMPZIPCreated with Sketch.ZIPXLSCreated with Sketch.XLSTXTCreated with Sketch.TXTPPTCreated with Sketch.PPTPNGCreated with Sketch.PNGPDFCreated with Sketch.PDFJPGCreated with Sketch.JPGGIFCreated with Sketch.GIFDOCCreated with Sketch.DOC Error Created with Sketch.
Question

Parts List / BOM

by
Bentley Communities Legacy Member
Expert
Created in MicroStation Forum

Hi,

I got a few question relating to  Parts List / Bill of Materials on microstation drawings.

Currently we create tables manually, but the problem we have then is that we don't know what parts are used on what drawings, so if we change a part we have to go through every single drawing to find out what drawings that part is on.

  • Is there some smart way of creating BOMs in Microstation? Ideally a way that would allow me to run a report from ProjectWise of all the drawings that contain a specific part. Similar to what AutoCad has (link)

Alternatively, is it possible to have a table that imports the list from a subset of an excel spreadsheet? e.g. if I have an excel table like the one below, can I create a table in microstation that links to the subset of the where Drawing No = 123-456? I know I can create  a table and specify that the Range (B2:E4) but if rows are added or deleted in the excel file that link becomes incorrect.

ABCDE
1Drawing No:ItemQuantityPart NumberPart Description
2123-45613A-1M12 Bolt
3123-45623A-4M12 Washer
4123-45631A-7M12 Nut
5123-78912A-1M12 Bolt
6123-78921A-4M12 Washer

Regards,

Mattias Carlehäll