Netsuite

NetSuite Saved Searches - The Ultimate Guide

February 22, 2024

Two women having a conversation

Although NetSuite provides numerous pre-configured reports, business needs often demand more intricate solutions, and certain data may not be readily accessible through these standard reports.

In such cases, the NetSuite Saved Search is a powerful tool, allowing businesses to customize queries and extract specific data tailored to their unique requirements. Getting started with NetSuite Saved Searches provides businesses with more flexibility in retrieving data, enabling them to gain deeper insights and address complex reporting needs effectively.

In this article, we will give you a complete guide of NetSuite Saved Searches, its best practices, and a walk through on how to create a Saved Search in NetSuite.

What Exactly is a NetSuite Saved Search?

You can think of NetSuite Saved Search as a tool that allows you to retrieve specific data from your NetSuite database using different search parameters. Through Saved Searches, users can further customize data by filtering, sorting, and presenting them in a way that aligns with their specific business needs.

Results from creating custom Saved Searches can also be displayed in NetSuite dashboard portlets, like Shortcuts, Custom Search, Key Performance Indicators (KPIs), KPI Scorecard, KPI Meters, Trend Graphs, and Reminders. 

How Do Saved Searches Work?

NetSuite Saved Searches allow you to access and organize information according to your business needs. Here's a general overview of how it works:

Creation

Create a Saved Search by navigating to Lists > Search > Saved Searches > New. Here, you can define criteria, filters, and columns to specify the data you want to retrieve.

Criteria

Set criteria to filter records based on specific conditions. For example, if you want to find all sales orders created in the last month, you would set the criteria for "Date Created" to be within the last 30 days.

Filters

Further, refine the search results by specifying conditions that records must meet to be included in the search. Filters can be based on fields within records, such as transaction type, item category, customer type, etc.

Results Columns

Users can choose which fields or columns they want to include in the search results. These columns display information from the records that match the search criteria.

Sorting

Saved Searches can also sort the results based on specific columns in ascending or descending order.

Customization

NetSuite provides a variety of options for customizing Saved Searches, including the ability to group results, summarize data, apply formulas, and more.

Integration and Automation

Saved Searches can be integrated with other NetSuite workflows, dashboards, SuiteScripts, and SuiteAnalytics, to automate business operations and gain deeper insights into data.

Step-by-Step Creation of a Saved Search

If you haven’t yet, here is a step-by-step guide to help you get started with creating your own saved search in NetSuite:

Selecting the Right Type of Search

  1. Go to Reports > Saved Searches > All Saved Searches > New.
Navigation to create new saved search
  1. Select the record you want to search on. Selecting the record type displays only the fields associated with the record.
List of search types

Setting Up Criteria

  1. Specifying the conditions that the records must meet to be included in the search results. Whether it's date ranges, transaction types, specific fields, or custom criteria, defining your criteria is necessary for accurate results.
Setting up Saved Search Criteria

Configuring Results for Maximum Efficiency

  1. Specify the results to display only the columns we want to see on the Saved Search.
Setting up Saved Search Results
  1. Click Preview to see the results of your Saved Search.
  2. Click Return to Criteria.

Utilizing Filters and Sorting Options

To further make it easier for users, you can add filters to your Saved Search.

  1. Go to the Available Filters tab.
  2. Select the filter you want to use.
  3. Check the Show in Filter Region checkbox.

Saving and Naming Conventions for Easy Access

  1. Once you've configured your Saved Search, remember to save it using descriptive and intuitive naming conventions.
  2. In the ID field, enter an ID and configure the Saved Search settings.
  3. Click Save.

Advanced Configuration

Take your NetSuite Saved Searches to the next level by exploring advanced configuration options:

Customizing with Formulas and SQL Queries

Go beyond basic search criteria by incorporating NetSuite Saved Search formula and SQL queries into your Saved Searches. Formulas enable you to perform calculations and create derived fields based on existing data elements. NetSuite Saved Search query provides even greater flexibility, allowing you to leverage the power of structured query language to access data in NetSuite.

Joining Multiple Saved Searches

Combine the results of multiple Saved Searches by leveraging join functionality. Joining allows you to integrate data from different search queries and consolidate them into a single cohesive dataset. 

Implementing Automation and Scheduling

Save time by automating repetitive tasks associated with Saved Searches. NetSuite offers robust automation capabilities that allow you to schedule Saved Searches to run at predefined intervals or in response to specific triggers. 

Email Integration and Management

Extend the reach of your Saved Searches by integrating them with email functionality. NetSuite enables you to email search results directly from the application to your stakeholders.

Saved Search Sections

NetSuite Saved Search is made up of different sections each with specific functions:

The Criteria Section: A Closer Look

The Criteria section allows you to narrow your search by determining which record types should be included in the results. It allows you to further specify your conditions based on fields, filters, and formulas. 

Setting up Saved Search Criteria

Results Section: Tailoring Data Presentation

In the Results section, you can customize how the search results are displayed. You can select the fields to include in the results, rearrange their order, and apply formatting options for better readability.

Setting up Saved Search Results

Audience Section: Managing Access and Permissions

The Audience section allows you to control who can access the search results and manage permissions for different users. You can specify who has the ability to view, edit, or run the search.

Setting up Saved Search Audiences

Highlighting and Filtering for Enhanced Usability

You can highlight and filter data to enhance the readability of your search. You can apply conditional formatting to highlight specific values or conditions within the search results, making important insights stand out immediately.

Setting up Saved Search Filters

Best Practices and Optimization Strategies for NetSuite Saved Searches

Given the right knowledge, you can maximize NetSuite Saved Searches to deliver results that are relevant to your decision-making process. Here are some Saved Search tips  and techniques you can explore:

Using Specific Naming Conventions

Establish clear and consistent naming conventions for your Saved Searches to facilitate easy identification and navigation. Consider including descriptive keywords that reflect the purpose of each search.

Optimize Search Performance and Results

Carefully craft your search criteria and select the most efficient search type for your needs. Minimize the use of complex formulas or excessive filters that can impact search speed and responsiveness. 

Schedule NetSuite Searches 

Schedule Saved Searches to run automatically at predefined intervals to ensure that critical information is delivered to stakeholders in a timely manner. 

Conduct Regular Review and Updates

Maintain the relevance of your Saved Searches by conducting regular reviews and updates. As your business evolves, your requirements also change. Update search criteria, refine results, and incorporate feedback from users to enhance the usability of your searches. 

Saved Search Types in NetSuite

There are various search types that help users retrieve data more efficiently. Understanding the different types of Saved Searches allows users to tailor their searches to easily capture their desired data:

Exploring the 7 Basic NetSuite Search Types

NetSuite offers 7 primary search types, each tailored to specific data retrieval needs:

  • Transaction Searches: Used to access transaction data such as sales orders, purchase orders, and invoices.
  • Item Searches: Used to find items, assemblies, and inventory stored within NetSuite.
  • Customer Searches: Enable users to locate customer records and related information in NetSuite.
  • Vendor Searches: Used for searching vendor records and related transactions.
  • Employee Searches: Intended for locating employee records and associated data.
  • Contact Searches: Used to find contact records linked with customers, vendors, or leads.
  • Custom Record Searches: Offer flexibility in searching for custom record types and their associated data.

Custom Searches for Specific Business Needs in NetSuite

On top of the basic search types, NetSuite allows users to create custom searches. Custom searches give users the flexibility to define unique search criteria, select relevant fields, and organize results according to their preferences. 

Leveraging Saved Searches Across Different Departments in NetSuite

Saved Searches can be leveraged to provide data relevant across different departments within the organization:

Sales and Marketing

Easily track leads, opportunities, and sales activities to prioritize follow-ups and forecast revenue. Segment customers based on demographics and purchase history to facilitate targeted marketing campaigns.

Finance and Accounting

Generating financial reports to analyze revenue streams and monitor expenses is another use case. Saved Searches also help in tracking budget allocations and monitoring spending patterns to identify areas for cost optimization.

Operations and Inventory Management

Monitor inventory levels and track stock movements. Saved Searches assist in managing order fulfillment processes by tracking order status and monitoring shipping and delivery schedules.

Troubleshooting and Common Challenges in NetSuite Saved Searches

Because of its robust capabilities, it’s normal to encounter challenges in configuring NetSuite saved searches especially during the learning curve. Understanding what are the common challenges and knowing how to troubleshoot them effectively can give you a good head start.

Performance Issues

Slow performance during search execution may occur especially when using complex search criteria and large datasets. To address this, optimize your search criteria by limiting the use of complex formulas or filters and consider scheduling searches during off-peak hours to reduce system load.

Data Inconsistencies

Inaccurate search results may stem from inconsistent data. Verify the integrity of your by auditing source records and validating that your search criteria matches the expected data format.

Permission Restrictions

Users may encounter access restrictions when attempting to run Saved Searches. Ensure that users have appropriate NetSuite Saved Search permissions to access the necessary records and execute searches. Likewise, review role permissions and adjust access levels as needed to prevent unauthorized access.

Formula Errors

Incorrectly configured formulas within your search criteria can result in unexpected search results errors. Double-check your formula syntax and test formulas in a controlled environment before deploying them in production searches. 

Integrating Saved Searches with your Business Processes

NetSuite Saved Searches serve as a foundational tool for extracting valuable insights that drive informed decision-making within your organization. It can also:

Enhancing Efficiency and Decision-Making

By leveraging Saved Searches to retrieve real-time data, it empowers decision-makers to make informed choices. Whether it's monitoring KPIs, tracking performance metrics, or identifying trends and patterns, Saved Searches provide the critical information needed to guide strategic initiatives.

Streamlining Procurement and Financial Controlling

Use Saved Searches to monitor vendor performance, track purchase orders, and manage inventory levels effectively. Financial controllers can leverage Saved Searches to reconcile accounts and generate accurate financial reports. 

Boosting Sales Performance and Forecasting

By analyzing historical sales data and customer trends through Saved Searches, organizations can develop accurate sales forecasts and anticipate market demand with greater precision.

Frequently Asked Questions

What is the Difference Between Saved Searches and Reports in Netsuite?

Do I Have the Ability to Export or Email Netsuite Search Results?

How Do I Create a Saved Search for a Report in Netsuite?

What Are the Limitations of Saved Search in Netsuite?

How Do I Add a Filter to the Bottom of My Search Results?

Latest Articles

NetSuite ACS vs Partner Support: Which One is the Best for You?

NetSuite ACS vs Partner Support: Which One is the Best for You?Getting the proper NetSuite support can make or break your implementation and ongoing success with the platform. But how do you know which support option best fits NetSuite ACS and NetSuite partners? This blog post breaks down the key differences between NetSuite’s Advanced Customer Support (ACS) and NetSuite partner support to help you make the choice that aligns with your business needs.Is your NetSuite implementation being held back by subpar support? Don’t leave your success to chance—understand the differences between NetSuite ACS and partner support to get your business's expertise.This blog post compares NetSuite ACS and partner support to help you determine the right support approach for your organization. We’ll explore the pros and cons of each option, from availability and response times to advanced expertise and cost considerations.‍What is NetSuite Support?NetSuite support assists with the range of ERP and omnichannel commerce capabilities within the NetSuite platform. This includes troubleshooting issues and answering usage questions on:‍NetSuite Financial ManagementNetSuite Order and Billing ManagementNetSuite Inventory and FulfillmentNetSuite CRM and MarketingNetSuite SuiteCommerce SitesNetSuite Reporting and DashboardsNetSuite Workflow AutomationNetSuite Customizations and Integrations‍Reliable support coverage for all NetSuite components is crucial for businesses to keep their systems stable, meet compliance needs, scale growth, and continuously optimize their platform utilization.NetSuite Advanced Customer Support (ACS)‍NetSuite ACS enables self-service access to the company's knowledge base with operational best practice content for finance, orders, inventory, and other areas. Users can also submit tickets for technical issues across modules like financial reporting, order workflows, and custom scripts.‍Dedicated account managers provide guidance on ACS entitlements and bundle purchases. But the support itself is siloed across topic-specific teams versus taking a holistic view of each customer's business priorities.NetSuite Partner Support‍Skilled NetSuite partners have extensive knowledge of the same core areas covered by NetSuite ACS, including:‍Troubleshooting platform errors and bugsAssisting with configuration and customization issuesProviding guidance on standard functionality ‍Additionally, the best NetSuite partners supplement ACS with a wider range of complementary support strengths, such as:‍Faster response times based on focused NetSuite expertiseDirect senior-level support unavailable through standard ACSVertical domain perspective tied to industry best practicesPersonalized account management aligned to business KPIsProactive solution checkups and optimization recommendationsOngoing training aligned to changing user rolesObjective guidance untethered from NetSuite sales ‍Customers benefit from comprehensive support coverage by leveraging both ACS and a partner like Seller Universe. ACS provides the backstop of direct vendor access while partners deliver specialized knowledge and context for greater productivity. The combined approach enables issues to be resolved faster while unlocking more platform value.‍NetSuite ACS: A Complete Overview‍NetSuite Advanced Customer Support (ACS) is the vendor's own technical support offering provided to NetSuite customers. It equips users with guidance and assistance to optimize configuration, utilization, and ongoing enhancement of their NetSuite ERP platform.‍Key features and services of ACS include:‍24/7 phone and email access to NetSuite support techniciansGuaranteed initial response times based on case severity Designated account managers for support planning and entitlementsDifferent support tiers aligned to customer needs‍Levels of ACS Support‍NetSuite ACS provides varied support levels to match unique customer requirements:‍Advise: Entry-level support ideal for new customers covers basic troubleshooting and product guidance to ensure a solid onboarding foundation.Monitor: Hands-on support with a designated functional consultant who monitors milestones are met across key workflows and processes. Optimize: For customers with more complex configurations, Optimize delivers deeper and proactive support for maximum utilization. This adds a Customer Success Manager and performance assessments.Architect: The highest tier designed for global and highly customized deployments. Adds an assigned Technical Account Manager for strategic oversight.‍Benefits of NetSuite ACS‍The main benefits NetSuite customers gain through ACS include:‍Direct access to NetSuite product experts who know the software inside and outProactive monitoring and regular platform checkupsGuidance on new functionality and process optimization‍Limitations of NetSuite ACS ‍Some downsides or constraints of reliance solely on vendor ACS:‍Incremental cost increases based on higher tiers of access and supportImpersonal support issues due to high volume of aggregate customers Locked into an annual contract regardless of actual usage or value gained‍Many customers switch to NetSuite Partners for maximum ROI for their support needs.Overview of Partner SupportNetSuite partners are expert implementation and support firms focused exclusively on the NetSuite platform. They provide a range of specialized services designed to help customers get maximum value from their ERP investment. Partners play an integral role by delivering solutions tailored to each organization's unique industry, business model, and objectives.Types of Services Offered‍NetSuite partners offer various services spanning the customer lifecycle including:‍Deployment - New implementations, data migration, integrationsCustomizations - Enhancements for specialized functionalityManaged Services - Ongoing administration and support packagesOptimization - Improving and evolving usage over timeSupport - User training to troubleshooting and upgrade guidanceBenefits of NetSuite Partner Support‍Partnering with a skilled NetSuite service provider yields many benefits:‍Customized Support: Partners provide individualized guidance based on deep understanding of customer goals and contexts. This enables more impactful solutions.Flexibility: Leading partners offer flexible and modular services. Customers can mix and match offerings to meet budget and requirements.Dedicated Attention: Partners provide senior-level, high-touch engagement and accountability across a customer's journey.Types of Support Plans‍NetSuite partners mostly offer two types of support plans:Ad-Hoc PlansFor more transactional or tactical needs, NetSuite partners offer flexible Ad-Hoc support plans. Under this model, customers pay per incident or project for needs as they arise. If an organization only has periodic platform issues or minor enhancements, paying only for specific partner engagements is often the right fit both functionally and economically. The Ad-Hoc approach provides nimble support refinements without unnecessary managed services overhead.Full Managed ServicesFor companies that rely heavily on NetSuite to run business operations, Full Managed Services delivers reliable support coverage on an ongoing basis. This proactive model includes regularly scheduled platform reviews, a technical account manager, and continual optimization to improve business process maturity over time. Instead of reactive troubleshooting, managed services provide end-to-end lifecycle enablement so technology fully aligns to ever-evolving functional requirements. The highest-performing partners offer Managed Services bundled to meet budget thresholds based on company revenue or headcount.‍Comparing ACS vs Partner SupportService Flexibility‍ACS offers tiered support packages but limited ability to customize service levels. Partners provide more tailored and modular options spanning ad-hoc firefighting to optimized managed services. This empowers a better fit to needs and budget. Customization and Personalization‍While ACS furnishes access to technical experts who understand NetSuite intrinsically, the vendor relationship limits customized enhancements aligned to strategic business goals. Specialized partners both conceptualize and deliver personalized solutions factoring industry contexts. Cost Efficiency‍ACS packages risk overspending without full utilization, as high-touch options have high labor costs. Partners enable pay-as-you-go flexibility or bundled managed services, driving higher ROI. The long-term TCO with partners can be lowered by distributing costs against value and outcomes vs. fixed ACS subscription fees.Response Time and Availability‍With massive customer volumes, ACS struggles to match partners’ rapid response times aligned to individual user priorities. Partners average 2-hour SLAs for P1 issues, while ACS urgent response is 8 hours. Users praise partners for 24/7 access and hyper-care during deployments.Strategic Guidance and Expertise‍While ACS resolves tactical issues, partners excel at strategic visioning and capability enhancements per business objectives. ACS acts as a platform mechanic, while partners serve as virtual CIOs. ‍‍Why is Seller Universe the Best NetSuite Support Partner?Comprehensive Solution BreadthSeller Universe provides an unrivaled breadth of solutions spanning financials, integration, automation, analytics, and custom application development. This enables a tailored fit to address diverse pain points out-of-the-box.Global and Local ExperienceWith skilled resources across North America and APAC, Seller Universe delivers in-region support backed by an intimate knowledge of local regulations, languages, and business norms. Our teams blend deep NetSuite expertise with on-the-ground insights.Industry and Process SpecializationSeller Universe offers pre-configured solutions fine-tuned for manufacturing, eCommerce, logistics, demand planning, AP automation, and more. With 300+ projects delivered, we furnish proven, repeatable models aligned to how you operate.Technology Depth and Platform ExpertiseWith 350+ NetSuite certifications and direct participation in NetSuite's product council, our consultants offer an unparalleled technical command of the platform's multidimensional capabilities. We match this with pragmatic implementation experience.Commitment to Continuous InnovationSeller Universe builds on NetSuite's core functionality through 250+ custom SuiteApps, integrations with leading complementary solutions, and our AutomationDrive RPA practice. We commit to continuously expanding what's possible, year after year.Final ThoughtsIn conclusion, NetSuite customers have options for supplementing the vendor’s Advanced Customer Support (ACS) offerings. However, realizing maximum value requires a partner that goes beyond basic break/fix services. The ideal support partner is a strategic advisor guiding customers through the ongoing enhancement of their ERP investment. This drives innovation aligned to business goals versus just maintaining the status quo.‍Of all specialized NetSuite partners, Seller Universe stands out as the clear market leader. By combining technical prowess with pragmatic implementation experience across hundreds of deployments, Seller Universe delivers unmatched ROI. We offer more than software support – We provide customers with a trustworthy, forward-thinking partner ready to evolve systems as needs grow and change.‍