How can I create an inventory usage saved search?
# ask-stanley-ai
s
How can I create an inventory usage saved search?
c
AI generated answer (using internal Slack threads):
To create an inventory usage saved search, follow these steps: 1. Navigate to the Saved Searches page in NetSuite. This can be found under Reports > Saved Searches > All Saved Searches. 2. Click on the 'New' button and select 'Inventory Item' from the dropdown list. 3. In the 'Criteria' tab, you can specify the conditions for your search. For example, if you want to find items that have not sold in 6 months, have no order and have no inventory in any location, you can add these conditions: - Date: set the range to the past 6 months. - Quantity on Hand: set to 0. - Quantity Available: set to 0. 4. In the 'Results' tab, you can specify what information you want to display in the search results. For example, you can add 'Name', 'Quantity on Hand', 'Quantity Available', etc. 5. If you want to make the search month specific, you can use a SQL formula in the 'Criteria' tab. For example, you can use the 'Formula (Numeric)' field and enter a SQL formula that calculates the number of months between the current date and the last sales date. 6. Once you have set up your criteria and results, you can save your search for future use. Remember, you can also use the 'Location Available' field in the results to get the quantity available for all the items for a particular inventory location. Just make sure to filter on Location in the 'Criteria' tab. ****** 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.861099482
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.857523739
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.855780125
Please provide your feedback on this answer.