Identifying Kit Components in Saved Search
I not positive that I’ve understood your question 100% correctly. But I think this might be helpful. We don’t use Advanced BOM, so I don’t know if that would change what I have below/
You can pull in “Member Of” which will tell which BOM’s an Item is used in. The only issue for what we were trying to do was that we could only get one level with that. We have a lot of subassemblies and often what we’re really trying to find is where is the next sub-assembly is used.
So we did a sublist on the item record that shows you what BOM’s the item is used in. We found that it’s easiest to start at the BOM level. From there you can pull in “Member Item” and “Member Quantity”. You can then do the filter on the “Member Item: Internal ID”.
So the Criteria was: Type – is any – Inventory Item, Assembly/Bill of Materials
Member Quantity => This will get you the Quatity used per build
Name => So this is pulling the BOM PN.
Description => So this is pulling in the BOM PN description because well it’s helpful
If you’re using it as a sublist you then add the “Member Item: Internal ID” as a filter. Then why you add it to the item record it makes sense. To Audit you’d need to add “Member Item” in the saved search results.
In order to see the next layer, so what builds those BOMS are used in we added a “Member Of” column. Because if you’re starting with the BOM then you can see both its contents and where it’s consumed.
Like I said I’m not fully sure that I’ve understood what you’re trying to so, but I hope that what I have here is somehow relevant.
Thanks for the pointers. Unfortunately, I’m looking at a transaction search as opposed to an item search and there don’t appear to be any equivalent “member of” fields.
I appreciate that I could look to the item details but I don’t think that would help me with a historic view of the kit.
To clarify, I’m looking to do this sort of thing:
Kit A (Cost: 0)
Component 1 (Cost: 100)
Component 2 (Cost: 200)
Kit A (Cost: 300)