Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Part Number and Revision in one column in Assembly Bill of Material

Saqib.Iqbal
Enthusiast

Part Number and Revision in one column in Assembly Bill of Material

Saqib.Iqbal
Enthusiast
Enthusiast

Looking to combine part number and revision in one column in assembly for our ERP system to export BOM from CAD model to ERP system but ERP system set up to have PART number with Revision as a name (example: <part number>-<revision number> or see attachment). Rightnow we copy BOM to Excel and make formula in one column to get what we want but would be good to have it ready in CAD BOM.

 

Thanks.

0 Likes
Reply
Accepted solutions (1)
511 Views
3 Replies
Replies (3)

smilinger
Advisor
Advisor

You can setup an iLogic rule and make the rule run on saving by add it to the Before Save event trigger.

iProperties.Value("Custom", "ABAS") = iProperties.Value("Project", "Part Number") + "-" + iProperties.Value("Project", "Revision Number")
0 Likes

bradeneuropeArthur
Mentor
Mentor

No coding needed:

make a new Custom I-Property like:

"ABAS" with the expression"    "=<Part Number>-<Revision Number>"

without "

regards

Regards,

Arthur Knoors

Autodesk Affiliations:

Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:Drawing List!|Toggle Drawing Sheet!|Workplane Resize!|Drawing View Locker!|Multi Sheet to Mono Sheet!|Drawing Weld Symbols!|Drawing View Label Align!|Open From Balloon!|Model State Lock!
Posts and Ideas:Dimension Component!|Partlist Export!|Derive I-properties!|Vault Prompts Via API!|Vault Handbook/Manual!|Drawing Toggle Sheets!|Vault Defer Update!


! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

0 Likes

Saqib.Iqbal
Enthusiast
Enthusiast
Accepted solution

Thanks all but I got my ilogic code working which add custom iproperty to assembly and all parts in that assembly, so that in BOM when you add that custom iproperties to the table, all parts/subasys have the information you want.

 

Here is the code, if someone also looking for it like i was:

 

Dim asmDoc As AssemblyDocument = ThisDoc.Document

iProperties.Value(Model, "Custom", "ABAS PN") = iProperties.Value(Model, "Project", "Part Number") &"-"& iProperties.Value(Model, "Project", "Revision Number")

Dim childDoc As Document

For Each childDoc In asmDoc.AllReferencedDocuments

Try

Dim filename = IO.Path.GetFileName(childDoc.FullFileName)

iProperties.Value(filename, "Custom", "ABAS PN") = iProperties.Value(filename, "Project", "Part Number") &"-"& iProperties.Value(filename, "Project", "Revision Number")

Catch
End Try
Next

 

 

If this answer your question, please give it a "KUDOS"

0 Likes