I am interested to change the format or syntax of item numbers in BOM from just numeric to letters and numbers (i.e., R1, R2, R3,..) and have it sequence automatically.
Is this possible?
Welcome to the forum. And no, I'm afraid I don't know of an easy way to do that.
Sorry not possible.
The only way I know of would be to assign a custom property to your components, using those designations. They would of course all need to be done manually. After doing that you could place a column in your BOM which is linked to this property, and sort by this column to put them in order, and also have balloons that reference this same property. As I said above, it isn't easy, but could be done if this is a requirement.
The only success I've had with manipulating quantities and item numbers is to use an Excel based BOM.
You can create new columns, concatenate info, use if/then/else statements, etc.
Manually modifying the BOM item numbers in the assembly seems to be the only way, except for what was mention with regards to use of Excel spreadsheets.
Is it possible to drive BOM in the assembly, or even in the drawing, from an external Excel spreadsheet?
Add an equation column to your BOM to the right of the Item No column (or add it anywhere and move it later).
Set the equation to "R" and select the Item No column from the drop down list.
This will concatenate "R" with the item number and it will update automatically.
(You may need to add some other punctuation/delimiters in the equation to satisfy its syntax requirements, but it's doable.)
Hide the regular Item No column.
For your balloons, you'll need to come up with a way to add in the "R" some how.
I don't believe balloons have the concatenate powers.
Perhaps it will let you reference your new BOM column. Perhaps not, bu if it does, select this.
This might be the deal breaker for your OP if balloons are required.
Edit: You also should rename your "R" item number column to "ITEM NO."
I wasn't able to use a regular BOM, like I posted previously, to address your issue.
But I was able to do so using an Excel BOM by concatenating "R" with the Item No value: (="R"&A2).
Note: You have to copy this formula down, else the RITEM cell will be empty.
On the plus side, you can copy down past what you think you'll need for the number of assembly parts and the displayed BOM only shows rows for the number of BOM items, not the extra rows that have the formula.
Once inserted, you'll need to hide the regular ITEM NO column and reposition the RITEM No column to its spot (plus rename the RITEM column heading).
I've attached the pack 'n go, the Excel BOM file and a PDF for a quick viewing,
I think this satisfies your post.
Thank you for the info. This worked out great...
Retrieving data ...