Duplicating and Modifying Saved Searches: A Guide to Efficient Reporting

Duplicating and Modifying Saved Searches: A Guide to Efficient Reporting

Duplicating and Modifying Saved Searches: A Guide to Efficient Reporting

This guide provides a fact-checked walkthrough of how to duplicate, modify, and manage saved searches effectively.

This guide provides a fact-checked walkthrough of how to duplicate, modify, and manage saved searches effectively.

This guide provides a fact-checked walkthrough of how to duplicate, modify, and manage saved searches effectively.

7 min read

Building a complex saved search from scratch can be time-consuming. A more efficient and reliable approach is to find an existing search that is close to your needs and duplicate it as a starting point. This strategy not only saves time but also allows you to leverage the proven logic and configuration of existing reports. This guide provides a fact-checked walkthrough of how to duplicate, modify, and manage saved searches effectively.


Why You Should Duplicate, Not Reinvent

Starting from a copy of a working search provides several advantages:

  • Time Savings: You don't have to re-create complex criteria, result columns, or formulas.

  • Consistency: It helps maintain a consistent structure and logic across related reports.

  • Leveraging Standard Reports: NetSuite provides a rich library of standard saved searches that are excellent, pre-configured starting points for common reporting needs.


How to Duplicate a Saved Search

  1. Navigate to and Run the Search: Find the saved search you wish to copy. You can find existing searches under Reports > Saved Searches > All Saved Searches.

  2. Use "Save As" to Create a Copy: Once the search results are displayed, hover over the Save button and select Save As from the dropdown menu.

  3. Rename Your Search: In the popup window, provide a new, descriptive name for your search.

  4. Confirm Creation of a New Search: Ensure that the option to Create a new search is selected. This guarantees that you are creating an independent copy and not just renaming the original.

  5. Click Save.

**Warning:** If you click **Save** instead of **Save As**, you risk overwriting the original search (if you have the necessary permissions). Always use **Save As** when your intention is to create a copy.


Key Areas to Modify in Your New Search

Once you have created your duplicate, you can tailor it to your specific requirements.

Area to Modify

Common Adjustments

Title

Rename the search to clearly reflect its new purpose. A good title is descriptive and unique.

Criteria

This is the most common area for modification. Adjust date ranges, change status filters, add new filters to narrow the results, or remove filters to broaden them.

Results

Customize the output. Add or remove columns, reorder them to fit your workflow, and add formula fields for custom calculations.

Audience

On the Audience subtab, define who can access and run this new search. You can make it private, public, or available only to specific roles, departments, or subsidiaries.


Best Practices for Naming Saved Searches

A clear naming convention is essential for a manageable and scalable NetSuite account.

  • Bad Names: My Search Copy, Test, New Sales Report

  • Good Names: Open Invoices - 60+ Days Overdue - US Subsidiary, Sales Orders by Rep - Current Month - Summary, Inventory On Hand by Location - Detail

A good name is descriptive and often includes the primary record type, key filters, and whether it is a summary or detail report.


Finding Good Starting Points

  • Standard Searches: On the "All Saved Searches" page, use the filter to show searches where the owner is "Standard." These are pre-built by NetSuite and cover a wide range of common business needs.

  • Public Searches: Look for searches that your colleagues have already built and made public.

  • Your Own Searches: Often, the best starting point is another search you have already created.

By embracing the "duplicate and modify" approach, you can build out a comprehensive suite of custom reports with speed and confidence.

Building a complex saved search from scratch can be time-consuming. A more efficient and reliable approach is to find an existing search that is close to your needs and duplicate it as a starting point. This strategy not only saves time but also allows you to leverage the proven logic and configuration of existing reports. This guide provides a fact-checked walkthrough of how to duplicate, modify, and manage saved searches effectively.


Why You Should Duplicate, Not Reinvent

Starting from a copy of a working search provides several advantages:

  • Time Savings: You don't have to re-create complex criteria, result columns, or formulas.

  • Consistency: It helps maintain a consistent structure and logic across related reports.

  • Leveraging Standard Reports: NetSuite provides a rich library of standard saved searches that are excellent, pre-configured starting points for common reporting needs.


How to Duplicate a Saved Search

  1. Navigate to and Run the Search: Find the saved search you wish to copy. You can find existing searches under Reports > Saved Searches > All Saved Searches.

  2. Use "Save As" to Create a Copy: Once the search results are displayed, hover over the Save button and select Save As from the dropdown menu.

  3. Rename Your Search: In the popup window, provide a new, descriptive name for your search.

  4. Confirm Creation of a New Search: Ensure that the option to Create a new search is selected. This guarantees that you are creating an independent copy and not just renaming the original.

  5. Click Save.

**Warning:** If you click **Save** instead of **Save As**, you risk overwriting the original search (if you have the necessary permissions). Always use **Save As** when your intention is to create a copy.


Key Areas to Modify in Your New Search

Once you have created your duplicate, you can tailor it to your specific requirements.

Area to Modify

Common Adjustments

Title

Rename the search to clearly reflect its new purpose. A good title is descriptive and unique.

Criteria

This is the most common area for modification. Adjust date ranges, change status filters, add new filters to narrow the results, or remove filters to broaden them.

Results

Customize the output. Add or remove columns, reorder them to fit your workflow, and add formula fields for custom calculations.

Audience

On the Audience subtab, define who can access and run this new search. You can make it private, public, or available only to specific roles, departments, or subsidiaries.


Best Practices for Naming Saved Searches

A clear naming convention is essential for a manageable and scalable NetSuite account.

  • Bad Names: My Search Copy, Test, New Sales Report

  • Good Names: Open Invoices - 60+ Days Overdue - US Subsidiary, Sales Orders by Rep - Current Month - Summary, Inventory On Hand by Location - Detail

A good name is descriptive and often includes the primary record type, key filters, and whether it is a summary or detail report.


Finding Good Starting Points

  • Standard Searches: On the "All Saved Searches" page, use the filter to show searches where the owner is "Standard." These are pre-built by NetSuite and cover a wide range of common business needs.

  • Public Searches: Look for searches that your colleagues have already built and made public.

  • Your Own Searches: Often, the best starting point is another search you have already created.

By embracing the "duplicate and modify" approach, you can build out a comprehensive suite of custom reports with speed and confidence.

Ready to Work Together?

Ready to Work Together?

Ready to Work Together?

Let us talk about your NetSuite challenges and how we can help. No pressure, no sales pitch. Just a straightforward conversation.

Let us talk about your NetSuite challenges and how we can help. No pressure, no sales pitch. Just a straightforward conversation.

Author

Michael Strong

Michael Strong

Founder & Principal Architect

Founder & Principal Architect

Tags

Read More

Read More