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?
Please Help!

Please Help!

Beginner Asked on March 1, 2023 in Saved Searches.
Add Comment
3 Answer(s)

Hi,

Have you set up a relationship between the two record? i.e. Parent/Child or Field pointing to the other record?

Thanks,

Chris

Intermediate Answered on March 1, 2023.
Add Comment

There is no relationship. Only they have some common fields.

Beginner Answered on March 1, 2023.
Add Comment

Then you can’t do that with saved searches.

SuiteAnalytics however allows you to join two datasets.

Intermediate Answered on March 1, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor