If I am using two custom fields for locations to a...
# general
m
If I am using two custom fields for locations to avoid hitting the 100 location limit... and those two fields has a parent-child relationship... can this get reflected in reports somehow? And can reports have an "or" criteria so we can get historical transactions plus the new ones that uses the new custom fields?
p
Yes NetSuite Saved Searches can handle this. You can use the parent/child custom fields as criteria/results, and NetSuite supports AND/OR expressions, so you can combine historical transactions using the old Location field with newer transactions using the custom fields. I can help structure the saved search/report so both the old and new location data are included without duplicating records. @Marawan مَرَوَان
m
@Praise Heritage Abayomi Yeah, I know that Saved Searches have advanced expressions, but I was wondering if reports can do this too or not?
p
You’re right to distinguish the two. Standard NetSuite reports generally don’t offer the same flexible AND/OR filter expressions that Saved Searches do. Report filters are normally combined with AND logic. For your specific case, combining historical transactions using the old Location field with newer transactions using the two custom fields—I’d recommend Saved Search or SuiteAnalytics Workbook rather than trying to force it into a standard report. NetSuite supports advanced AND/OR expressions there. @Marawan مَرَوَان
🤝 1
m
Hmm, got it. Thanks!!!