Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Saqib.Iqbal
508 Views, 3 Replies

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

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.

smilinger
in reply to: Saqib.Iqbal

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")

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 !

Saqib.Iqbal
in reply to: Saqib.Iqbal

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"