Saved search showing quantity available summed for locations containing “Lot” in the location name

AI generated answer (using internal Slack threads):

To create a saved search that shows the quantity available summed for locations containing “Lot” in the location name, you can use a formula in the results tab of the saved search. You can use a

CASE

statement in your formula to check if the location name contains "Lot" and then sum the quantity available for those locations. Here is an example of how you can do this:

sql
CASE WHEN {inventorylocation} LIKE '%Lot%' THEN {locationquantityavailable} ELSE 0 END

This formula checks if the inventory location contains "Lot" in its name. If it does, it returns the quantity available for that location. If it doesn't, it returns 0. However, this will return the quantity available for each item in each location that contains "Lot" in its name. If you want to get the total quantity available for all items in all locations that contain "Lot" in their name, you would need to use a summary saved search and sum the results of this formula. Please note that this method requires knowledge of SQL queries and is considered an advanced, unsupported method in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******