Ron
04/22/2025, 7:25 PMCeligo AI
04/22/2025, 7:25 PMAI generated answer (using internal Slack threads):To find the number of receipts of an item for the last year, you can create a custom saved search in NetSuite. Here are the steps: 1. Navigate to
Reports > Saved Searches > All Saved Searches > New.
2. Select Transaction as the type of search.
3. On the Criteria subtab, add the following filters:
- Type is Item Receipt
- Date is within Last Fiscal Year
- Item is [your item]
4. On the Results subtab, add the following fields:
- Name (this will be the item name)
- Document Number
- Quantity
5. (Optional) On the Summary subtab, you can group by Name and sum Quantity to get the total number of receipts for the item.
6. Save and run the search.
This will give you a list of all item receipts for the specified item for the last fiscal year, along with the document number and quantity for each receipt. If you used the summary options, you will also get the total number of receipts for the item.
Please note that this is a general approach and might need to be adjusted based on your specific NetSuite setup and requirements.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/22/2025, 7:25 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825827181
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.801112652
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.798414767
Celigo AI
04/22/2025, 7:25 PM