Hi all. I’m trying to modify a Saved Search. We se...
# general
c
Hi all. I’m trying to modify a Saved Search. We sell Kits/Packages, Assemblies, and Inventory Items. I want to display all items on sales orders but only show the Member Items of a Kit/Package, rather than the Kit/Package itself. The problem I’m having is that I end up showing the Member Items of Assemblies as well. Is there a way to have a search show all items on sales orders where Kit/Packages are split into their Member Items, but Assemblies aren’t affected? So my end search would show (1) Member Items of Kits, (2) Assemblies, (3) Inventory Items. Thank you all!
p
Maybe easiest to just introduce an additional checkbox or similar, that you can add on the ones you want to show and add that filter to search
m
In result , use fomula like this CASE WHEN {itemtype} = 'Kit' THEN {item.memberitem} ELSE {item} END