create saved search to get inventory available per...
# ask-stanley-ai
j
create saved search to get inventory available per location for lot items
c
AI generated answer (using internal Slack threads):
To create a saved search to get inventory available per location for lot items, you can follow these steps: 1. Navigate to
Reports > Saved Searches > All Saved Searches > New
. 2. Select
Item
as the record type for the saved search. 3. In the
Criteria
tab, add a filter for
Inventory Location
and set it to the specific location you want to check. 4. In the
Results
tab, add the following fields: -
Name
(this will display the item name) -
Location Available
(this will display the quantity available at the specified location) 5. If you want to filter by lot number, you can add a filter in the
Criteria
tab for
Inventory Detail > Lot Number
. 6. Save and run the search. Please note that this will only show the current inventory levels. If you need to get historical inventory levels, you might need to use SuiteQL or create a transaction saved search, as NetSuite doesn't offer much in terms of historical inventory reporting. ****** 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.869228065
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850775957
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845787346
Please provide your feedback on this answer.