running a saved search of inventory, client wants two locations combined, so for every inventory item instead of showing 4 locations they want 3 locations. A) Is this possible? B) How?

It's probably doable using a formula and summary search. I.e. text formula field with something like

CASE WHEN {location} IN ('Location 1', 'Location 2') THEN 'Merged Location' ELSE {location} END

that you group by

Getting ERROR: Invalid Expression

That was untested, but we don't hold inventory so I can't test with anything at the moment

Right on, appreciate the thought

Or you could try CASE WHEN {location} = ‘Location 1’ THEN ‘Merged Location’ WHEN {location} = ‘Location 2’ THEN ‘Merged Location’ ELSE {location} END If this is an item search you might need to use {inventorylocation} instead of {location}

yes this works to merge the location field, but what about all the other fields associated with the item inventory location? They want all those fields merged as well. sum of location on hand, location lead time, location reorder point, that sort of data they want merged as well. So basically merging together the two lines per item in the saved search. is that possible?

Yes then you would put a summary value to make it a summary search Item = Group Description = Group Your formula text field = Group Location on hand = sum Lead time = Max Reorder point = sum Stock level = sum

This appears to have solved it! Thanks!