Change saved search to show inventory locations in Columns instead of rows
I have created a saved search to help our purchasing team handle the demand plan recommended transfers. I have it working, but it is missing some vital information that I am struggling to add.
First we only have 2 inventory locations that we move stock between, but we have 3 others that are inactive but always show up on a saved search so that's problem 1. I would love to exclude the other three from results but I can't seem to make it work. I think because I have to setup a transaction search instead of item.
Second issue is for each transfer, I show five rows (1 for each location). I would like to show the available quantities for each location (preferably only the 2 active ones), in the columns instead of rows. Like the total in the last column of the attached screenshot. I have also attached my criteria and results parameters. If there is a way to do what I am doing that would be great or if you have better more efficient way of accomplishing the same thing I would be thrilled. Thank you Guru's, you are all