2 Replies Latest reply on Sep 29, 2016 1:11 PM by jeff@viavi

    How to sort BOM with Reference Designator

    ks.lokesh@lnttechservices.com

      Expedition Output > Bill of Materials dialog report where it is exporting by Ref Designator sorted, it is displaying one Ref Designator per line, Count for those list of Ref Designator using exporting by Ref Designator sorted is there. Count is only included it with the BOM report exported for Part Numbers list sorted.

       

      I need a BOM with Mechanical parts included in it, All mechanical parts either top most or bottom most. Something similar to below example:

       

      ITEM
        (USED WITH)*
      QTYPART NUMBERDESCRIPTION
      11L16904-BPC BOARD BLANK
      31E3768-4LABEL
        0.25 X 2.50
      4 (D4, Q1)*2S8025-80#6
        SELF TAPPING SCREW
      5 (D4, Q1)*2CF000004#6-32
        X .500 ROUND HEAD MACHINE SCREW
      6  (D4, Q1)*2E106A-13#
        6 LOCK WASHER
      7AS REQE1868THERMAL
        JOINT COMPOUND
      8  (D4, Q1)*2S18104-14HEAT
        SINK,ALUMINUM,EXTRUDED,2.0
      9  (D4, Q1)*2S9262-3#
        6 OR # 8 PLAIN WASHER
      10 (D4, Q1)*2T13746#6-32
        HEX NUT 3445
      REFERENCESQTYPART NUMBERDESCRIPTION
      C1, C212S20500-5CAPACITOR,PPMF,.0015,2000V,BOX
      C2, C3, C83S13490-186CAPACITOR,ALEL,1800,160V,20%
      C41S20500-2CAPACITOR,PPMF,0.47,630V,10%,BOX
      C5, C182S25029-3SMTCAPACITOR,SMD,ALEL,100MF,35V,20%
      C6, C17, C19, C204S25020-27SMTCAPACITOR,SMD,CER,0.1MF,50V,-20%+80%,Z5U,S0805

       

      I am not sure how everyone exporting their BOM's, Could you please help me on this.

      Appreciated your help!

       

      Thanks

      Lokesh K S

        • 1. Re: How to sort BOM with Reference Designator
          Patrick.Cashman

          The answer to your question is fairly complex.

           

          The fundamental idea in play with creating BOMs from the Xpedition flow is that there is not a very good way to include mechanical parts in a PCB database.  Unless a component has logical pins with through or surface pads, it becomes difficult to create, add, and manage them in the PCB database.  Additionally, the Variant Manager is not well suited to take care of them.

           

          We have the further problem that our ERP system, SAP, requires a very customized BOM file format, so the part list generation tools in both Xpedition and DxDesigner are not capable of creating the files in this format.

           

          Thus we have solved the problem by doing the following:

           

          - We create schematic symbols for mechanical parts.  We have a table in our DxDatabook database for them.  Each part has a symbol with no logical pins, so there is no need for a corresponding cell and packaging.  The Forward to PCB attribute in the symbol definition is set to False. The symbols have properties for Part Number, Quantity, Ref Designator, and Schematic Value.  Ref Designator becomes Item Number on the BOM.  The policy is that every bit of hardware that goes on the PCB Assembly gets included in the schematic. In this way, the schematic is in 100% control of the design and everything included in it, and the schematic is always in sync with the BOM.

           

          - We have an automation application that creates the BOM files from within the schematic.  This application was written from scratch to exactly suit our needs of including the mechanical parts, not including things like mounting holes and e-points, accommodating the complete functionality of the Variant Manager, and creating the BOM files as they are needed for use with SAP. Additionally we separate all of the SMT parts in their own BOM so that our assembly machines and processes don't have to try to separate them out later on. 

           

          There is no quick and easy way to get an accurate BOM from DxDesigner or Expedition that does everything you want, and gives you the format you want.

          • 2. Re: How to sort BOM with Reference Designator
            jeff@viavi

            You best bet is with a script.  Take a look at the script that Sandi Bottanu wrote: Expedition PCB: Bill Of Materials - Just another BOM script