topic Re: BOM branch qty in Vault professional in Vault Customization Forum

BOM branch qty in Vault professional

Anonymous — Tue, 15 Dec 2015 14:06:14 GMT

Hi everyone,

Is it possible to get the quantity of branch in rolledup bom:

ES. BOM

Item Qty

-A

--B 2

---C 3

Rolled up

Item Qty

B 2

C 6

If not, I think linq could help me but I don't know how.

Thanks

Re: BOM branch qty in Vault professional

wayne.brill — Tue, 22 Dec 2015 20:39:55 GMT

Hi,

Can you provide a code example that is not working? I am not sure how to research this question. Are you using a function similar to GetItemBOMByItemIdAndDate() and then the ItemAssocArray property of the ItemBOM?

One of the arguments to GetItemBOMByItemIdAndDate() is the BOMViewEditOptions Enumeration. Maybe by changing this you can get the values you need in the returned ItemBOM. (ItemAssoc objects in the ItemAssocArray)

This DevBlog post could be of use:

http://adndevblog.typepad.com/manufacturing/2014/06/change-row-order-of-item-in-a-bom-vault-2015-example.html

Thanks,

Wayne

Re: BOM branch qty in Vault professional

Anonymous — Fri, 25 Dec 2015 10:15:00 GMT

Thanks for your help,

I tried in this way:

Dim bom As ItemBOM

bom = m_mgr.ItemService.GetItemBOMByItemIdAndDate(selectedArticolo(0).Id, Date.Now, BOMTyp.Tip, BOMViewEditOptions.BOMRolledUp)

For Each articolo_assoc As ItemAssoc In bom.ItemAssocArray
MessageBox.Show("padre_ID " & articolo_assoc.ParItemID)
MessageBox.Show("articolo_ID " & articolo_assoc.CldItemID)
MessageBox.Show("quantità " & articolo_assoc.CldItemUsage)
Next

but I can only get the leaves item and quantity, not the branches item with quantity.

E.G. tree view bom

Item qty

-B 2

--C 1

-D 1

Results (SelectedArticolo A)

padre_ID articolo_ID quantità

A C 2

A D 1

What I need is:

padre_ID articolo_ID quantità

A B 2

A C 2

A D 1

Any Ideas?

Re: BOM branch qty in Vault professional

adam.nagy — Tue, 05 Jan 2016 18:53:46 GMT

Happy new year!

Got the following comment from a colleague:

>>>>>

Vault Pro supports a “parts-only” view which would show the 6 C’s, but since A & B are both assemblies, they would not be present in a parts-only view.

However, there is nothing to stop someone from getting the item BOM and doing the rollup themselves in a way that works with their data.

<<<<<

Cheers,