This message was deleted.

some key differences between reports and saved searches in NetSuite: Purpose and complexity:** Reports are usually used for straightforward data extraction and can be easily generated using NetSuite's report builder. Saved searches, on the other hand, provide more advanced querying functionality, allowing you to build complex queries using SQL-like logic. Flexibility:** Saved searches are more flexible than reports. They allow you to display calculated fields, perform grouping and summarizing data, display results from multiple types of records, and use formulas. Reports have limitations on these aspects. Joining Records:** With saved searches, you can join to many other record types and. Reports have limited capabilities to join tables. Ease of Use:** Reports are more intuitive and user-friendly. Saved searches require a deeper understanding of NetSuite's database schema and data structure. Scheduling and Sending:** Both saved searches and reports can be scheduled and sent via email. However, saved searches have more advanced options, such as sending individual emails to each result of a search. Access to System Fields:** Saved searches have access to many system fields (like created date, last modified date, etc.) that aren't available in standard reports. Performance:** For large data sets, reports can perform better than saved searches, as saved searches can take more time and resources if they're not optimized. In summary, reports are often simpler and faster to set up for straightforward data retrieval and summarizing, while saved searches offer more advanced functionality and flexibility, but may require more time to set up and optimize.

thank you much appreciated for this info

How do you control join type in a Saved Search?

I'd bet my house on this being a ChatGPT answer. And as Michoel pointed out, not 100% accurate..

@David B Obviously it's a Gpt response, it's not hard to see… we can only validate the fact that the saved search allows joins ( inner joins )that the report cannot do as powerfully