topic Inventor Bom quantity column order customize in Inventor Programming Forum

Inventor Bom quantity column order customize

bionorica2015 — Sun, 27 Feb 2022 14:04:39 GMT

Hello!

I have BOM from assembly,

Order in left ipart list and order in bom specification (as shown in picture) are not similar,equal.

Are there ilogic codes or another method to sort quantity column order as in parts list.

How can I order quantity columns in BOM of assembly without drag and drop.(If I have iparts with 100 quantity columns. it will be difficult to sort them by order.)

Thank You!

Re: Inventor Bom quantity column order customize

James_Willo — Mon, 28 Feb 2022 06:41:50 GMT

Hi Azizxon, I am not fully understanding what you are trying to order here and by what.

If you want your iAssembly to have a specific member order, a quicker way to do this is by using the excel editor from the iAssembly editor. You can use the sort function in there and when you save and return, Inventor will update.

If you want a specific order in your BOM based on your iAssembly, you could try adding a custom column with numbers in, in your iAssembly table and then use this to sort in the BOM.

Re: Inventor Bom quantity column order customize

johnsonshiue — Mon, 28 Feb 2022 19:20:04 GMT

Hi! I see the behavior. I think you are talking about the iAssembly member list in the browser vs the one on the BOM table. The one on the BOM table is sorted alphabetically (or numerically). The one in the iAssembly browser is actually from the author table.

To make them in sync. Go to iAssembly factory -> edit the table in Excel -> Sort the Member column.

Many thanks!

Re: Inventor Bom quantity column order customize

bionorica2015 — Tue, 01 Mar 2022 02:30:27 GMT

Hello!

Thanks for answering. But

Going to "iAssembly factory -> edit the table in Excel -> Sort the Member column" changes ipart list in browser, not the Bom table.

In the contrary, I want to change Bom table quantity columns order to the browser IPArt list order.

Waiting for your answer!)

Re: Inventor Bom quantity column order customize

James_Willo — Tue, 01 Mar 2022 06:12:36 GMT

Hi, sorry if I misunderstand here, there seems to be a few different questions.

Order in left ipart list and order in bom specification (as shown in picture) are not similar,equal.

Regarding the image you posted, the drop down in the BOM will always be a-z/1-10 and will not match your browser order.

another method to sort quantity column order as in parts list.

You want to sort by quantity in the BOM, is that right?

Click this icon (ignore the 300, that is my iAssembly config):

This all seems too simple, so do you actually mean you want these columns sorting left to right alphanumerically?

As far as I know there is no way to do this. If you use these same columns a lot though, you can export a BOM configuration and import it to another assembly at the bottom of the BOM window.

Re: Inventor Bom quantity column order customize

johnsonshiue — Tue, 01 Mar 2022 20:46:23 GMT

Hi! As James indicated, I am not aware of a way to sort BOM table based on iAssembly member list.

Many thanks!

Re: Inventor Bom quantity column order customize

bionorica2015 — Wed, 02 Mar 2022 15:22:48 GMT

Is there Ilogic or coding solutions for sorting BOM qty columns ?

Re: Inventor Bom quantity column order customize

bionorica2015 — Wed, 02 Mar 2022 15:23:53 GMT

Is there Ilogic or coding solutions for sorting BOM qty columns ?

Re: Inventor Bom quantity column order customize

James_Willo — Wed, 02 Mar 2022 15:56:37 GMT

I'm not an iLogic specialist, but there was a similar question on adding columns to the BOM through iLogic and the answer was no, so I suspect there is no iLogic control of columns.

Re: Inventor Bom quantity column order customize

bionorica2015 — Sat, 19 Mar 2022 15:03:50 GMT

Please help with this ilogic code:

https://forums.autodesk.com/t5/inventor-forum/vba-ilogic-rule-to-rename-model-parameter-names/td-p/11015699