Hello everyone, I’m trying to create a saved search for cases, but cannot figure why multiple lines are reporterd for each case (sometines 7, sometimes 2...)
m
michoel
11/12/2020, 8:22 AM
Share a screenshot of your search criteria and result subtabs
l
LRG
11/12/2020, 8:22 AM
It seem to be linked to the shipping addresses :s
n
Netsuite Tragic
11/12/2020, 9:52 AM
@LRG on which record type are you stating your search? and which records are you linking? Most probably it's one of the Joined records, so try it without. Then if that is it, Group everything and your Joins with a Max Summary type.
l
LRG
11/12/2020, 9:54 AM
Thank you for your help to both. I managed to filter by adding a "Default Shipping address = true". But it’s weird that Case transactions shows one record line for each address on the customers record.
s
Sean Murphy
11/12/2020, 11:02 AM
This is Normal behavior for NetSuite in all Areas. If you include address and do not specify which address it shows one row for each of them all of them.
l
LRG
11/12/2020, 3:47 PM
But, I did not add addresses in my saved search. The case saved search seem to link sublist record with addresses without a particular address field.
n
Netsuite Tragic
11/13/2020, 5:52 AM
Post a screen shot of your Results tabs and the fields you are including please.