Has anyone tried to do a saved search join from an Item Saved Search to the related Manufacturing Routing record for the assembly? I can never find that join in an Item Saved Search

Analytics/query is much better for getting advanced bom data. You typically need multiple joins to get all the information since revisions, boms, items, routings are all separate records.

Ok thanks. I would need it as a Saved Search to trigger a workflow, but it sounds like that's not available.

@AI1 for saved searches in this case reconsider the starting record. find a record that joins to Item & Manufacturing Routing. Maybe you could do it from a Work Order or Assembly Build

Thanks that does work to for viewing information. But scheduled workflows triggered from saved searches can only use saved searches made from the same record type as the workflow. So a workflow updating item records need to have an item saved search It’s just surprising that the join doesn’t exist. I can go from MFG routing and join to item record but not the other way around Oh well thanks for everyone’s input

@AI1 you might consider doing something in two passes to first update one field which can pass the info onto a suitable Item saved search. or, create a script to post the MFG routing info onto the Item. A script will do it neatly in one pass.

Thanks I agree a script is probably the way to go