Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
How to create parent, child relationship for cases
I dont think this is available as a standard option in NetSuite. I am trying to create a work around for this.
This is what I came up with, but I dont have enought SQL knowledge to figure this out.
I am trying to create the 'subsidiary of' relationship using custom fields as a workaround.
Create a custom field 'parent case:' of type list/record >> cases.
Create another custom field 'child cases:'
You can see the parent on all the children if you do this. But how do you automatically set a default value on the 'child cases:' field to source the case numbers of all cases that have current case # equal to 'parent case' #.
0