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

Hi,

It feels like this should be easier than it seems to be!

If you are happy with them both in a single field then a Formula (Text) like this will work:
NS_CONCAT({location})
N.B. With NS_CONCAT, you need to make sure the Summary Type is either Minimum or Maximum.

To get them in separate fields will require  some further manipulation as part of that formula.
Here’s an example that gets the to and from in separately:

REGEXP_SUBSTR(NS_CONCAT({location}),'^[^,]+')
REGEXP_SUBSTR(NS_CONCAT({location}),'[^,]+$')

Thanks,

Chris

Intermediate Answered on October 7, 2020.
Add Comment

Your Answer

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