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.
Custom records saved search
Hi,
I wanted to create a saved search coming from 2 custom records, with these structures:
Custrecord1
Store - List/Record (Store Location custom record, which I set as parent)
Work Cost - Currency
Hour - Integer number
Work date - Date
Custrecord2
Store - List/Record (Store Location custom record, which I set as parent)
Sales - Currency
Hour - Free-Form Text
Sale Date - Date
These 2 custom records have one common parent record. I created a saved search from the parent custom record Store Location with this criteria:
Criteria:
Location = <store name>
(Custrecord1 Work date = last week OR
0