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
If you want the information on the same row, then you should use the Summary Type column. Set a column that is unique like Internal ID as the Group column to group rows with the same internal id togerther as one row. Then you can use Maximum or Minimum on your formula columns from the SuiteAnswer article to get the biggest or smallest value of the grouped rows. The formula is setup to basically have only one value, so the minimum and maximum are the same value.
