This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

i want saved search formula for inventory number not end with 24

&gt;*AI generated answer (using internal Slack threads):*
To create a saved search formula for inventory numbers that do not end with '24', you can use the following formula in the criteria section of your saved search:

```
Formula (Text): RIGHT({inventorynumber},2) != '24'
```

This formula uses the `RIGHT` function to get the last two characters of the inventory number, and then checks if these characters are not equal to '24'. If the last two characters are not '24', the inventory item will be included in the search results.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1607635941101600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.831136405

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1629792753171200|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.83024931

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1666122099881679|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.829432964



Please provide your feedback on this answer.