Is there a way to create a search that would show ...
# suitescriptt
Timothy
07/03/2019, 10:54 PMIs there a way to create a search that would show available to build on assembly items? I have 1000s of assembly items with negligible build times that I need real time stock levels. Whether or not it’s considered in stock is equal to what can be built. Items vary in depth and components but I need real time numbers rolled up to the top assembly. “In Stock - 4 Available” I can do it with a flattened search and a whole lot of JavaScript recursion but it feels like a stupid amount of overkill. Any thoughts?
b
battk
07/03/2019, 10:57 PMYou might be able to do it with a summary search
battk
07/03/2019, 10:58 PMThe basic idea is to group by assembly internal id
battk
07/03/2019, 10:58 PMAnd have a column which calculates how many assemblies each component item can create if it was the only component
battk
07/03/2019, 10:59 PMThe minimum value of that column is how many assemblies you can make
battk
07/03/2019, 11:20 PMif you want to be clever in a script, you can try abusing dynamic mode to create an assembly build and set the fields required to calculate the buildable quantity for each assembly item
t
Timothy
07/03/2019, 11:39 PMI’ll give the summary a shot first. I haven’t done much with summary searches so maybe that’s what I’m missing. I have assemblies with assemblies as components, 3-4 levels deep so I’ll probably still need some scripting
b
battk
07/03/2019, 11:40 PMwell, hopefully their available and on hand quantities work
battk
07/03/2019, 11:41 PMif this was kit items, you would not be able to do that since their quantities dont work in searches
4 Views