Save search of items missing list price

AI generated answer (using internal Slack threads):

Based on the conversations, it seems you can create a saved search to find items that are missing a list price at a certain level. Here's how you can do it: 1. Create a search using your normal criteria to find items. 2. Under the search criteria, under the Summary tab, add a row where the Summary Type is "Maximum", the field is Formula (Numeric). Set the formula value to be equal to 0 and use the following formula:

CASE WHEN {pricing.pricelevel} = 'Your Price Level' AND {pricing.currency} = 'Your Currency' THEN {pricing.unitprice} ELSE 0 END

3. Click "Use Expressions" and duplicate the row, adding an "Or" criteria with the following formula to also account for other pricing:

CASE WHEN {pricing.pricelevel} = 'Your Other Price Level' AND {pricing.currency} = 'Your Other Currency' THEN {pricing.unitprice} ELSE 0 END

4. Under the results tab, use the same formula(s) to create columns for the pricing, using Formula (Currency) this time and a Summary Type of "Maximum", with "Group" as the Summary Type for your other columns. As it turns out, the Summary type is important and is where you might get stuck because if you don't put it in, you get a row for each price level. 5. Create an email alert for this search so that you can be proactively alerted whenever there are items that appear that don't have the specified pricing. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******