Unit Qty For Multiple Assemblies

[T_Haynes]

I was wondering if it was possible to have the unit qty help calculate our cut list,  currently we're having to manually enter the unit qty and total qty. All parts are pulled from one assembly. Everything else is currently pulling from our part files.  

[steveh1]

I believe models states will do this. 2022 and above. We r just making move to 2023, but I think I tested this in the beta 

Best,

[T_Haynes]

We are using a standard assembly not an iAssembly, is it possible to change the unit qty on this menu? I don't know enough about model states to use them correctly.

Thanks

assembly

[A.Acheson]

What does you BOM look like for these parts? Your BOM should contain the information to total this up. If it doesn't you can automate the partslist with summing column/ ilogic. 

To clarify are you looking to produce batch qty's even thou your main assembly has qty 1 on paper? If so this should only be changed in the partslist of the drawing/excel. 

[T_Haynes]

Here's the Model Data view, we're pulling the cut list from this assembly, but need to be able to change the cut list for multiple units, currently doing that manually which leaves room for error. There is multiple sub assemblies in the phantom assemblies, all individual parts are calculated correctly. I hope this helps explain the situation better.

Thanks

 

[A.Acheson]

I see your wanting to use the partslist as like a summing tool for multiple orders.  Inventor by default doesn't work like this as this is normally handled externally by specifying how many sub assemblies in an inventory software. But there are work arounds but will need a little help from ilogic code. Is your preference to do this calculation in excel using the exported partslist or on the parts list in the drawing itself? 

[T_Haynes]

Yes, we want to be able to produce batch qty's in our drawing partslist, right now we have to manually updated the unit qty and tot qty. we want to be able to choose the unit qty and it automatically update the total qty.

[T_Haynes]

Calculations in the parts list in the drawing.

[cadman777]

When I want to show part quantities or total lengths of materials for 'x' number of top level assemblies (so I can show all the parts in the entire project in the PartsList), this is how I do it:

1. Create a new assembly and insert the top-level assembly into it,

2. Array that assembly however many times is needed.

3. Make that new assembly the BaseView in the drawing, but set it off the visible sheet.

4. Make a new PartsList based on that view.

5. Format the PartsList as desired.

I realize this is another 'work-around', but it works, is quick, and doesn't involved any coding.

Hopefully I understood your request properly.

[A.Acheson · Accepted solution]

Here is what will do that work for you.  Change the Columns Names to what you want. 

' Ask Project Qty from User Via Input Box
Dim ProjectQty As Integer = InputBox("Enter a Project Qty", "Project Qty", 1)

'Set the Column names
Dim QtyColName As String = "QTY"
Dim ProjectQtyColName As String = "Project Qty"
Dim TotQtyColName As String = "TOT Qty"

Dim DrawDoc As DrawingDocument = ThisDoc.Document
Dim PartsList As PartsList = DrawDoc.ActiveSheet.PartsLists.Item(1)
Dim Cols As PartsListColumns = PartsList.PartsListColumns

Dim QtyCell, ProjectQtyCell, TotQtyCell As PartsListCell

For Each Row As PartsListRow In PartsList.PartsListRows
	'check if Calculation Column Exist
	Try
       QtyCell  = Row.Item(QtyColName)
 	   ProjectQtyCell = Row.Item(ProjectQtyColName)
	   TotQtyCell  = Row.Item(TotQtyColName)
	Catch 
		'Add the Columns
		Cols.Add(PropertyTypeEnum.kCustomProperty, , ProjectQtyColName, , False) 
		Cols.Add(PropertyTypeEnum.kCustomProperty, , TotQtyColName, , False)
	End Try
	 
	Try
		'Reference each cell
		QtyCell  = Row.Item(QtyColName)
		ProjectQtyCell = Row.Item(ProjectQtyColName)
		TotQtyCell  = Row.Item(TotQtyColName)

		' Set the Project Qty from User Via Input Box
		ProjectQtyCell.Value = ProjectQty
		 
		 'Do the Calculation
		TotQtyCell.Value = ProjectQtyCell.Value * QtyCell.Value
	Catch
	End Try
Next

[T_Haynes]

This worked exactly how I needed!

Thank you.