Is it possible to do a saved search for a Work Ord...
# suiteanalyticsb
Brian
03/18/2021, 8:57 PMIs it possible to do a saved search for a Work Order (WO25), that shows other Work Orders those components from WO25 are on?
n
Netsuite Tragic
03/18/2021, 8:59 PMYes
b
Brian
03/18/2021, 9:06 PMThanks @Netsuite Tragic How would you approach that? When I filter my transaction search by the document number, I limit my search results to only that transaction.
n
Netsuite Tragic
03/18/2021, 9:51 PMA couple of ways. I’m thinking start as saved search of Items not Work Orders. btw, Does the WO contain multiple assemblies?
b
Brian
03/18/2021, 9:59 PMYea - I started down that path as well...Not really having much luck. Basically what I'm trying to do is create a saved search that lists the components for the item being built. Then show all the other work orders those components are on.
Brian
03/18/2021, 10:03 PMThe 'component of' filter returns subassembly members (I think) which im not looking for, just want the top level assemblies in the BOM
n
Netsuite Tragic
03/18/2021, 11:15 PMI'm thinking of a Result colum using LISTAGG({transaction.number}) to give a field of all the WO for an Item. Then do a INSTR to see if your WO is in that string
Netsuite Tragic
03/18/2021, 11:26 PMThat is a tough one. Here are the Result columns I used.
Netsuite Tragic
03/18/2021, 11:27 PMOrdering it by the first Formula(text) at least gave me the list I could view at the top. Hopefully someone might have a clue on how to resolve it.
b
Brian
03/18/2021, 11:35 PMI’ll mess with it tomorrow, this is helpful, thanks