I am trying to build a saved search that can perform available inventory comparison between two locations. It will display inventory items that have low inventory less than or equal to 2 at one location, and if the same items have inventory available at another location equal to or greater than 2, so we then use that information to perform inventory transfers. Ideally, I want to then use the saved search and try to build a scheduled workflow to then create auto inventory transfer records. I currently have a saved search which lists columns of available inventory by each location. We then have to export the saved search into excel and then filter down the list of items based on above comparisons, and then create inventory transfers via csv imports. Again, at this point I am trying to build a saved search which will eliminate the use of excel.
NetSuite Saved search – available inventory comparison between 2 locations
This sounds like more information than you are going to be able get into a single saved search. Most likely running multiple searches and vlookup-ing between is the simplest solution here. Or you could go down the path of building a suitelet and running multiple searches and combining the data in code and displaying how you like.