https://netsuiteprofessionals.com logo
Join Slack
Powered by
Anyone else having issues with a saved search retu...
# suiteanalytics
j
Anyone else having issues with a saved search returning duplicate results, but only for some roles? Admin role returns single opportunity as expected, but sales roles are returning lots of duplicates.
k
Can you share your search setup? What you suggest is occurring is... unlikely
Are you sure it's role based and not user based?
j
I know I doesn't make any sense, but I have tried several roles and it is hit or miss. I am getting lots of complaints from our sales team because they have hundreds of opportunities in a list when it should be less than 50.
k
are you sure they are duplicates and not results that shouldn't show up?
I.e. maybe your search criteria is set to exclude results based on something that the user can't see - and so it returns those results incorrectly?
j
The criteria is pretty basic. It is an Opportunity Search
message has been deleted
k
What is your result set?
j
message has been deleted
k
Do you use sales teams?
I'd also be inclined to set mainline true (granted - I don't know if mainline applies to opportunity search when not using transaction search instead)
j
No, that feature is not turned on.
k
Are any of your included fields a "multiselect" field?
j
Mainline was the first thing I tried, but it isn't available on opportunities.
k
I'd try removing fields 1 at a time to see if that changes results returned
(save off a second version)
j
No multiselect fields are being used in this search.
The strange part is this search was worked correctly for months. Then as the end of last week I started getting some complaints about it duplicates and it hasn't been edited. The only main difference would be our 2020.2 upgrade occurred at the end of last week.
I will see if removing fields one at a time will correct the issue.
k
Any chance you use multiple versions of opportunities? I.e. Best case/worst case/expected?
I'd try and figure out which duplicated lines are there and how they are different from the ones that don't duplicate.
j
I think I will try that approach. There are some that aren't being duplicated.
It appears that they have changed the search functionality on Opportunity transactions because it is related to the number of items on the item sublist. The problem is they didn't add in the ability to filter by mainline on the Opportunity.
k
There's got to be a way to filter out items.
Maybe say "item = none" or something like that?
j
I will see if I can get that to work.
It still ignores the item sublist when you search on an admin role. Very strange.
k
That is definitely strange - and probably worth filing a defect with NS Support
j
I heard back on my ticket and they said it was a known defect. Defect 600309 :  Custom Role > Customer record > Sales subtab > Opportunities > Saved Search Shows Duplicate Results
2 Views
Open in Slack
PreviousNext
Powered by