why is the count of system notes records different...
# ask-stanley-ai
p
why is the count of system notes records different between the user interface for a transaction and a saved search
c
AI generated answer (using internal Slack threads):
The count of system notes records can be different between the user interface for a transaction and a saved search due to several reasons: 1. Filters: The user interface might have some filters applied that are not present in the saved search. For example, the search might have a result for Document Number which doesn't show up on the transaction in the UI. 2. Role and User: If different roles and users are used for the UI and the saved search, the results might differ. It's recommended to use the same role and user for both to ensure consistency. 3. Record Type: System notes are, in their own way, a record type in and of themselves. So, if you're doing a search for each record type, you might miss some system notes. Instead, you can do a "System Notes" saved search. 4. Grouping and Summarization: If you're trying to get a count of how many transactions a user edited, you need to group by User and Transaction to make the combination unique and then sum or count the unique values. If you're only grouping by User, you might get a sum of each of the changes in the system notes, which can inflate the count. 5. Date Restrictions: If you don't have any date restrictions, the saved search might look at everything since you've gone live in NetSuite, which can result in a larger count. Applying a date restriction can help get a more accurate count. Remember to always double-check your saved search criteria and results to ensure accuracy. ****** 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.832950473
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828163862
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826395273
Please provide your feedback on this answer.