RE: Identifying Kit Components in Saved Search

Hi,

I’m working on an IF Saved Search and trying to roll up any Kits but I can’t seem to find any fields that identify the kit line to which the components belong.

Any help / advice would be much appreciated.

Thanks,

Chris

Chris Abbott Intermediate Asked on January 5, 2021 in Saved Searches.
Add Comment
2 Answers

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

Results is:

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.

Beginner Answered on January 5, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.