How to add custom record’s field in saved search?
I am creating saved search on custom record ‘A’. Putting criteria on ‘A’s custom fields. Now I want to put criteria for custom record ‘B’s custom field on same saved search. Some custom fields are common on both custom record ‘A’ and ‘B’. But Custom field for which I have to add in criteria is available only on custom record ‘B’. How can I put Custom record ‘B’s field in criteria of custom record ‘A’s saved search?
I want to validate that field. Or is it possible through suitescript?
Have you set up a relationship between the two record? i.e. Parent/Child or Field pointing to the other record?
There is no relationship. Only they have some common fields.
Then you can’t do that with saved searches.
SuiteAnalytics however allows you to join two datasets.