What is the best way in NetSuite to find out how m...
# ask-stanley-ai
c
What is the best way in NetSuite to find out how many new records were added in a time period (both NetSuite standard records and custom records)?
c
AI generated answer (using internal Slack threads):
In NetSuite, you can find out how many new records were added in a time period by creating a saved search for each record type you want to track. In the criteria of the saved search, you can specify the date range for the 'Date Created' field. This will give you a list of all records of that type that were created within that time period. You can then use the 'Results' tab to count the number of records returned by the search. For standard records, you can directly create a saved search. For custom records, you need to navigate to the custom record type and create a saved search from there. Here is a step-by-step guide: 1. Navigate to the record type you want to track. For standard records, this is usually under Lists, Records, or Transactions. For custom records, go to Customization > Lists, Records, & Fields > Record Types. 2. Click on 'Saved Searches' > 'New'. 3. In the 'Criteria' tab, add a new criterion. Select 'Date Created' as the field, 'within' as the operator, and specify your date range. 4. In the 'Results' tab, add a new result column. Select 'Internal ID' as the field and 'Count' as the summary type. 5. Save and run the search. The count of records created within your specified date range will be displayed in the results. For a more automated approach, you can use SuiteScript to programmatically create and run these searches, and SuiteAnalytics for more complex data analysis. Remember, if you are dealing with a large number of records, performance can be an issue. Consider using techniques like SuiteQL for more efficient querying, or using parent-child relationships for custom records to improve performance. ****** 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.840271
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835388184
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833862364
Please provide your feedback on this answer.