AutoCAD Electrical

[#1]

I recently spent time trying to track this down so I thought I would post what I did here.

I was trying to generate a BOM using the "Display in Tallied Purchase List Format" and got my list but there were too many Item numbers listed per Item Number. It is not readily apparent that you need to click on the "User Post" button to gain access to the checkbox "Suppress ITEM column repeats." This will remove all the extra iterm numbers listed in the Item Number Column. Unfortunately, this does not stick, so you have to select it each time you run a report.

Now, if we could only get rid of the blank lines left over... Trying to delete them removes the whole item number. I am currently looking into using the User Post to remove them and will reply if I find anything.

[#2]

This is a bit of a kludge, but if you go into the table and delete all the blank lines within the field of each cell in a row, you are then able to shrink that row down to a manageable size.

[#3]

You can stop the item numbers appearing in the Tallied BOM altogether.

Run the report, and then click on the Change Report Format button.

Find the ITEMS field in the report section and remove it.

Now save the format and you have a tallied list that can be given to purchasing personnel.

You can set up various reports like this as long as you use seperate file names for each one.

Regards Brad

[#4]

Brad, the format of the list was not the problem. I still want the items displayed in the BOM, just not so many of them. It arrtificially makes the list longer than it needs to be. From what I can tell, the extra lines are placeholders for all the TAG values associated with listed when the quantity is more than the descriptions available for tha particular catalog number (5 to 6 lines). I have not been able to discover how to access this yet. Maybe someday...

[#5]

Brad

I wish to ask a question about what you are saying.  Do you mean that if you have two relays that are the same part number you are getting two line items rather than a could ot two?

If yes I am having the same problem but my saving grace is that my project are not that big.

Cheers  John Q

[#6]

This is what I am referring to.

This is how the reports generates:

This is how I want it:

Just selecting "Suppress ITEM number repeats" is not enough. All this does is replace the ITEM number with a CR in the report. I still have to go into each cell and delete these CRs (because they are not only in the first cell) before I can move the line up.

I am surprised that no one has come up with a fix for this after all these years...(unfortunately, my Lisp skills are very primitive at this time)

[#7]

Bob, make a copy of your original pur_pbom.lsp file and replace it with the attached version.  Then add the following line to the end of your report format file and the post process to remove repeated item numbers will execute automatically. 

User Post Process = 3

This is the way I've done it for years.  But since version 2011 allows me to item number in order of manufacturer, I no longer need the tallied purchase list format.  I just use the standard Panel BOM.

[#8]

Doug,

That worked great for automating the User Post 3 but I still have the problem with all the empty rows per item number section (see my jpegs above). I suppose you would never notice if you accept the tags listed along with the items because they would fill up the empty rows in the TAGS column but I do not want the tags in the BOM.

Thanks anyway,

[#9]

That's true.  The software is holding a place for the tags.  I report tags so it has never been a problem for me.  DIN/IEC drawings usually don't track according to item number but according to Device ID.  If you look at a typical DIN/IEC material list you will see all tags associated with each part number listed.  That's just the way it has been done in the past.  Of course with AutoCAD Electrical I can display both item numbers and tags.

[#10]

I rewrote the User Post 3 part of the pur_pbom.lsp so that it now erases all other iterations of the item except the first one. My BOM Report is now much cleaner.

Here is the file for anyone else that wants to use it.