how to create a saved search that returns results ...
# ask-stanley-ai
n
how to create a saved search that returns results if a certain inventory number has an item quantity committed to it or not
c
AI generated answer (using internal Slack threads):
To create a saved search that returns results if a certain inventory number has an item quantity committed to it or not, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the type of search you want to create. In this case, select 'Item'. 3. In the Criteria subtab, you can add filters to your search. To check if a certain inventory number has an item quantity committed to it, you can use the 'Inventory Number' field and set the operator to 'is'. Then, input the inventory number you want to check. 4. In the Results subtab, you can choose which fields you want to display in your search results. To display the quantity committed, you can add the 'Quantity Committed' field. 5. If 'Quantity Committed' is not available, you can use a formula to calculate it. The formula is
{quantityonhand}-{quantityavailable}
. To add this formula, click on 'Formula (Numeric)' in the Results subtab, and input the formula in the Formula field. 6. Click Save & Run to run your search. Remember, this search will return all items with the specified inventory number, and display whether they have a quantity committed or not. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840374291
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83056134
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830313087
Please provide your feedback on this answer.