This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Sorry for another question:

I am trying to show the Drop Ship Vendor Bill and the related Customer Invoice posting period to check if they match or if the other one is created but the other is not. Is it correct to say that's it's not possible through a saved search due to join limitations? I would love to use a saved search but it seems to be not possible. My alternative though is SuiteAnalytics Workbooks if I am right. Thank you.

yup, you cannot have multi level join in saved search, so suiteanalytics is only way

CASE WHEN {transactionlines.nextlinks.nextdoc^transaction.type} = 'Invoice' THEN {transactionlines.nextlinks.nextdoc^transaction.postingperiod#display} ELSE 'Not Yet Created' END

Tried this in the Dataset but it's not throwing the correct values. Everything shows Not Yet Created although there's an Invoice already (Type = Sales Order) Any idea? Thank you.