Hello,
I'm trying to create a saved search for pending approval inventory transfers to show in the results the item, from location, to location and the current quantity on hand in a single line but I'm not sure if this is even possible. I have tried several times but nothing. This is what I have set in criteria and results:
And this how the results show, they are filtered by a single transaction. What I'd like to have here is only one line showing the from and to location if possible (not sure if this is possible)