I have a Manufacturing routing saved search on which I am not seeing certain item, in the criteria it's only Item Type : Assembly and Inactive is false. we recently turned on the Advanced Bill of Material and this is one of the item that was updated for the new BOM. can you guide me the direction to see what i am missing

there is not a item record on the Routing record...a little confusing why it is an available join. You can see "Component" but this is not the same as "Item : Name"

I think that is what we did, this is the criteria

when you run the search do you see values for internal id, name, and description?

yes I do see them

is the BOM where you are missing at item a new one, created after Adv. BOM was enabled?

yes

that is probably the issue then -- it appears the "Item..." only works when associated with legacy BOMs. I ran a couple tests and saw the same behavior if you change the new routing to a legacy BOM the items should show up

aha but reason we changed to advanced bom is to get more visibility so should we change all the items to the new boms and then we can see all the items?

A SuiteAnalytics workbook could likely get you the joins you need...but this changes the results layout significantly.

hmm ok, haven't used workbook feature yet, might need to play around with that.

it will get you past the double join limitation, but depending on your use-case here the data definitely exists so i would start there....if its not fitting the need you may want to look at a scripted solution or using multiple searches (may not be ideal but its possible)

hmm thanks, will need to see how the workbook operates, haven't used it yet. Thanks for showing the guiding light