How to have two or more items having the same value in a particular column but being different parts
- merged and balooned with one number
- have the quantity column show the sum of the items.
Right now when I go to parts list, group settings, group by first key, pick common value, the balloons will still show different number although they will be grouped and sumed up in quantity column. And the item column will show 1,2,3 for each separate part instead 1 for all 3 with one common value.
Take a look at my thread and see how much of it applies to what you are needing.
http://forums.autodesk.com/t5/Autodesk-Inventor/Parts-List-BOM-Configurations/td-p/3381933
It looked like you were in a similar boat as I was. I am thinking like I had to do, edit the bills of material like I showed in my thread and by playing around with the component selection settings (i.e.reference etc) it might give you what you are looking for.
In Group Settings, What does unchecking the Display Item Numbers (1,2,3) box do?
You could try grouping them in the BOM as well.
It will leave the parts list field blank but baloons will be still numbered the same way they would be with the field checked.
There is no grouping in BOM. There is an option of "Part Number row Merge Settings" but not an option for a merge using custom iproperties, what would work for me.
Any way of substituting and merging part numbers instead of showing a whole bunch of them?
Maybe ilogic?
Maybe something along the lines:
If PART NUMBER is this, ballons and item number in parts list is that? could that work?
Considering the number of times Parts List/ BOM/Ballooning problems come up and the number of unsatisfactory results are found.... I WONDER IF ANYONE AT AUTODESK HAS MADE THIS A PRIORITY FOR NEXT YEAR'S UPDATES HINT...HINT
Anyone knows if ilogic rule withing .idw file would be able to fix the problem?
Hi Infoseeker,
I think it would be helpful to provide a screen shot of the results you're trying to get. Can you overide the balloon and parts list to create a mock up?
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com
I will try to do that but what I want is quite simple.
I want all the numbers you can see in the .jpg I attached to be merged into one number.
I dont want different numbers displayed for substituted parts (in baloons and parts lists) - I want one.
The best thing would be if I could actually drive this number and not depend on the assembly order.
So perfect scenario would be if I was able to call out parts with the same characteristic (iproperty) with the same number (baloon, row in parts list) instead of having them listed as on the screen shot I attached.
Thats why I thought of ilogic, becase it seems it might be simple and quick solution. Each drawing file would have to have a formula ordering it to group all the items in a parts list... Well, substituting takes care of this, the formula would have to merge in parts lists all the parts with the same iproperty and give them a nuber that I want.
i may be looking at this too simply but...
if the PARTNUMBER field is identical, then the parts will be meged in the parts list.
just edit the part number field in all the parts you want meged to be identical.
First of all I am using two custom iproperties as a common value, not PART NUMBER, that was just an example. Also for this columns I use substituting. I wish it was this simple.
maybe you could reasses your non use of PARTNUMBER as this is the only field i know of that inventor will merge rows on
you could do a code to propogate the PARTNUMBER field with the custom properties you are using
(as soon as 2 parts have some partnumber, they will be merged...as long as its ticked in the rowmerge properties box from the bom...you can also add exceptions so certain conditions will not merge)
If I do it your way, in my Quantity column I will have *Varies* value because this values are different for each part. If I disable Merge I will have some crazy numbers of parts with the same number, I want to have then in one row, with value for Quantity summed up (I use substitute option for that).
I still think the easiest might be to have ilogic rule in .idw file that forces parts list to show one number fof a baloon for all the parts with one particular iproperty but did not have time to figure it out.
I dont know if you guys figured this out or not, but I'm having a similar dilemma.
I would like to have three different parts, with three different part numbers, shown "as normal" as far as item number, quantity and part number to be different for each row. and one column called assembly grouped together to show one assembly number. Is this possible? Please see the attachment.
There wouldn't be any way to automatically get that number in there like that, that I know of.
How may assemblies would you have per drawing?