ACE BOM to item numbers

[robertstbl]

Currently when I generate my BOM report per drawing the Item number column is not filled in. When I am inserting a component I do not put an item number on it. Is there a way to do this when I insert my BOM? This way I can add my bom in the drawing from excell and ballon in item numbers?

[lionSG]

Hi,

Did you try the import/export data tab and export the panel components to spreadsheet (excel) first?

Then edit the item number in excel and import back to the drawing again.

Add the balloons to the necessary panel components with the correct item numbers.

Thanks.

[robertstbl]

Ok I just tried that but did not see anywhere to specify the item number. I currently am running a report for BOM in the active drawing and tried to edit the item number. Then inserted a ballon and then it asked me for an item number, how can you link the item numbers in the colum to the ballon. Attached is the drawing in question.

[dougmcalexander]

There is an Item Number Resequence utility on the Panel menu tab.  Version 2011 enhanced this such that item numbering can be alphabetical by manufacturer.  Version 2013 further enhanced this so it back annotates schematic components with the associated item number from the panel layout.  I always assign item numbers project wide using this utility.  It takes seconds and is perfectly sequenced.  I sort my BOM my item number and, since the item numbers were assigned alphabetically by manufacturer, the manufacturers are listed as AB, ABB, etc.

[robertstbl]

Thats what I was looking for THANK YOU!!!

[dougmcalexander]

Hint: If you wish to assign item numbers to subassembly parts, you must set this up in Project Properties on the Components tab (see attached screen capture).  Note that you can only assign item numbers to subassembly parts that are assigned via the Multiple Catalog, not subassembly relationships that are created using an Assembly Code.  Either use the Assembly Code method or the Multiple Catalog method for a project, not both.