I'm struggling to prepare saved search which shows inventory transfers in one line instead of two. As some you you know, inventory transfer search shows movement of item in two lines: one adds quantity (positive) to location, another line subtracts quantity from another location My goal is to show all these fields in one line: item, quantity, from location, to location. Anybody done this before?

Have you tried using

Transaction Line Type

, I believe adding criteria for whichever you want (shipping/receiving)

already tried, it is just empty

Can probably make 2 formula columns to do modular arithmetic on the line ids and show the location for each

Using Sandii two formula approach you can get the From Location with a formula like CASE WHEN {quantity} < 0 THEN {locationnohierarchy} ELSE null END. Then appropriately Group your results so you get a single line.

so finally I made it 🙂

Is that Quantity column working for you? I was thinking thinking it needed to be Max (or Min) as Sum 300 + (-300) would give zero.