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

Intermediate Asked on January 5, 2021 in Saved Searches.
Add Comment
2 Answer(s)

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

Hi ssteenstrup,

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)

Thanks,

Chris

Intermediate Answered on January 6, 2021.

Chris,

Did you ever find a solution for this? I am trying to do something similar.

Thanks,

Scott

on November 22, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor