How to differentiate lines in Inventory Transfer in saved search? quantity greater than 0 turns all lines

AI generated answer (using internal Slack threads):

To differentiate lines in Inventory Transfer in a saved search where quantity greater than 0 turns all lines, you can use a combination of formulas and grouping in your saved search. Here's how you can do it: 1. Create two formula fields in your saved search. One for 'From Location' and one for 'To Location'. 2. For 'From Location', use the formula:

CASE WHEN {quantity} < 0 THEN {locationnohierarchy} ELSE null END

This formula will return the location when the quantity is less than 0 (indicating a subtraction from a location). 3. For 'To Location', use a similar formula but for quantities greater than 0 (indicating an addition to a location). 4. Group your results by the item and the transaction so that you get a single line for each inventory transfer. Remember, the 'From Location' and 'To Location' fields will show the location from which the item was transferred and the location to which the item was transferred, respectively. Also, be careful with the Quantity field. If you are summing the quantities, a positive and a negative of the same number would sum to zero. You might need to use Max (or Min) instead of Sum for the Quantity field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******