BOM Varies error in Excel

[shajan_durairaj]

Hello all,

I am using a customized content center part and inserted a multiple numbers in assembly.

In that item no 8, in that the POS.no is mentioned as 8 that i have given through instance property because i cant able to add in content center as this number change with respective with the sub-assembly. but in Inventor BOM it looks good, But after exporting the BOM to excel the thumbnail is not showing and it is mentioned as varies.

Can you guys give a solution how to get the thumbnail after adding the instance property, or other way to add that number.

[JoshuaNAM]

Hi,

I think it would be recommendable to unselect "Part Row Merge" in the BOM editor. Then check if all the parts that are being merged are identical. "Varies" in this case means that there are parts in your assembly that are being merged but have a different thumbnail.

I hope this helps you out a bit!

Kind regards,

Joshua

[johnsonshiue]

Hi! This could be a bug or there are incompatible property values between the member components merged in the same row. Please share the files here. I would like to understand the "Various" value better.

Many thanks!

[shajan_durairaj]

After Doing those steps also the error is still there,

The value I have given through the instance property in the BOM that is affecting the thumbnail but I noticed there is no change in the thumbnail,

I need a solution that after adding the instance property also the thumbnail to be visible, please give a solution if possible.

[shajan_durairaj]

Hi Sir,

As per your request the step file is attached for your reference, please have a look and give the solution if possible because I was trying this for long time.

[johnsonshiue]

Hi! Please zip up all the Inventor files (iam and ipt) and share it here. The iam file is just a wrapper referencing other iam and ipt files.

Many thanks!

[shajan_durairaj]

Hi Sir,

The document is attached for reference.

[johnsonshiue]

Hi Shajan,

Many thanks for sharing the files! But it does not look the same as the images you posted earlier. Please tell me the steps to reproduce the exact behavior on Test.iam.

Thanks again!

[shajan_durairaj]

Hi Sir,

Can you check this Zip file Please and let me know you are still facing the same.

[johnsonshiue]

Hi! I think I have to show what I saw on my machine. This is the BOM table I am seeing when opening the attached assembly. It does not look like the image you attached earlier. Please show me the exact steps to reproduce the problem. I am very bad at guessing.

Many thanks! 

[shajan_durairaj]

Hi Sir,

Sorry for the confusion, the one which you are seeing in your machine is same as the picture which i attached at first (That is full assembly, for test i gave small sub assembly)

And the second picture is exported to Excel.

Now i will add the problem which i am getting and the procedure to make that.

Above mentioned both two are the content center part and in that content center table properties i added some properties and the same will reflect through out the assembly.

like this above mentioned bought out property is mentioned in the content center table and when i inserted HEX.HEAD SCREW it will display and if you see in the POS (position) that will change with respective to the size and place we are attaching, So i need to have a different position number through out the assembly to where i added.

So i though of adding the position number in the instance property.

And want to change the drawing number too in instance property

After adding that it will become like this

 Now i am going to export the BOM in excel

Without adding the instance property, the BOM will look like this

But after adding that

when we given the instance property the thumbnail is coming as varies apart from that everything looks good, 

This is my query and whether it can be solved or any other way to give a position and drawing number in the BOM For the content center files.

Hope you understand if you have more clarification, please revert.

[johnsonshiue]

Hi! Many thanks for sharing the detail steps! I can reproduce the behavior on my machine. Indeed, this seems to be related to the existence of Instance Properties. The instance property merges the rows by default. They are supposed to be different rows since each instance has a property value. Inventor assumes they have different thumbnails. As a result, they are exported as "Varies."

If you click on "Part Number Row Merge Settings" button in the middle at the top of the BOM dialog and uncheck "Merge Instances Rows," you will see the thumbnails will look right (no "Varies"). But each instance is listed as a separate row, which is not desirable either. Unfortunately, I don't think there is a way to get the desirable result.

Many thanks!

[shajan_durairaj]

Thank you for your reply, Sir. I understand that it cannot be done.

If you got any answer in future, means pls let me know.

[gyurcsan_gyorgy]

Hello Sir!

Is there any solution for that? In Inventor 2025 the same problem appears.

Many Thanks.