RE: Saved search: transfer order – no “To Location” data

The {location} field on an Inventory Transfer saved search seems to contain both the ‘from location’ and the ‘to location’ resulting in one transfer order search generating multiple lines

  • the first line {location} results with the ‘from location’ data and
  • the second line for the same transfer ID {location} results in the ‘to location’

If filtered with ‘main line’ true then you get one line per transfer but only ever the ‘from location’, never the ‘to location’.

Need to get a saved search to produce, in one line, both the ‘to’ and the ‘from’ locations.  Looking at the transfer in GUI the ‘transfer from location’ is: [Field ID: location] and the ‘transfer to’ field is: [Field ID: transferlocation].

The issue is that putting {transferlocation} on a saved search always returns -none-.

 

Closest Answer Id: 32418  sort of addresses that this is an issue but the suggested use of:

Formula (Text) | Formula = case when nvl({quantity},0) < ‘0’ then {location} else null end | Custom Label = From Location

Formula (Text) | Formula = case when nvl({quantity},0) = ‘1’ then {location} else null end | Custom Label = To Location

–>  Does not get both data points on one line.

 

Looking for Transaction saved search

Critera =

  • Type is Inventory Transfer

Results=

  • Date, Group
  • Document Number, Group
  • Amount (Credit) , Sum

Need (on the same line, could then be concatenated)

  • Transfer from location
  • Transfer to location
mlajewsk Rookie Asked on October 6, 2020 in Saved Searches.
Add Comment
11 Answers

From NetSuite Support:

As per checking of your case message, I understand that your concern is about populating the ‘To Location’ and ‘From Location’ of your Inventory Transfer saved search and have them in one line only.

Per my initial investigation using the preliminary details you provided, I was able to confirm that functionality that you are looking for is an existing system limitation. Inventory Transfer saved searches are currently only allowing the ‘Location’ field to show both the ‘TO’ and ‘FROM’ locations in different line.

We understand that the aforementioned feature will be beneficial for you. Fortunately, there is already an Enhancement request logged for the same concern, details of the Enhancement are as follows:

178607 List > Search > Saved Searches > New > Transaction. Please include ‘To & From Location’ field that sources from Inventory Transfer.
I can attach this case to add a vote to the above enhancement. Our system engineers periodically reviews these enhancements and hopefully be implemented in our future releases. Please note that there is not specific time-frame for its release though.

Please upvote this Enhancement request (178607).
Thanks!

Rookie Answered on October 21, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.