NetSuite Saved search – available inventory comparison between 2 locations

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.

Rookie Asked on September 30, 2020 in Saved Searches.
Add Comment
1 Answer(s)

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.

Intermediate Answered on September 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor