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


  • 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

Indeed the single-quote copied from the forum was causing the error. Thanks!

Not getting the error now but am getting (which may help/confuse the other issue) the same location returned for ‘^[^,]+’ as ‘[^,]+$’.

Now it seems to not be an issue with those formulas (I think they are working as they are supposed to) but the data in NetSuite and thus what is shown in the results of NS_CONCAT({location}).

Those results look like this (Store A is the from and Store B is the to location) this is all returned in one field:

Store A,
Store B,
Store B,
Store B,
Store B,
Store A,
Store A,
Store A,
Store A,
Store A,
Store A,
Store A

This happens on all transfers even just one item transferred once from Store A to Store B.

‘^[^,]+’ is correctly pulling the first location in the list Store A

‘[^,]+$’ is correctly pulling the last location in the list Store A

The issue seems to be in figuring out why NS has the ‘from location’ listed 8 times and the ‘to location’ listed 4 times… and why in the jogged order it is in?


Again thank you for your assistance on this!


Rookie Answered on October 7, 2020.
Add Comment

Your Answer

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