AnsweredAssumed Answered

How to sort BOM with Reference Designator

Question asked by lokesh_kannappan on Sep 29, 2016

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

Outcomes