top of page
Post: Blog2_Post
—Pngtree—check light blue pattern background_2079635 (1).png

Blog Article

Mastering NetSuite Saved Search: Limiting Results Beyond Criteria

Ely Beltran

Written by: Ely Beltran


Background


In a NetSuite Saved search, the number of results would be based on the criteria. There are some instances


where only a particular number of results are needed. Here are example use cases where showing a certain limit of results is ideal:

  • The saved search has 100,000 results, but the user would only like a sample of 100. Running this search and displaying the results would take some time. Adding a criterion to limit the number of results is one way of limiting the results, but the user would still need to determine the proper criteria.

  • The large number of results from the saved search would be read by a script, but processing a large dataset would clog the scripting queue. Ideally, the developer would like to process only 1000 records with each run.

This tutorial will demonstrate how to set a certain limit on the results in the saved search.

Saved Search ROWNUM Criteria

  1. Edit any existing Saved Search

  2. Add a new Criteria.

  3. Select Formula (Numeric), this will open a new window.

  4. In the new window, add the following field values:

  5. Save and Run the search.

  6. The search should only show 10 results, this is due to the ROWNUM formula added to the criteria.



Etter+Ramli as the Trusted, Independent Managed Services Provider for NetSuite

Using NetSuite Managed Services could be your growing company's best strategic move. NetSuite Managed Services offers a comprehensive solution, granting companies access to a team of experienced NetSuite administrators and consultants to manage their NetSuite ERP. Typically, this service is more affordable than hiring in-house staff. When you use managed services, your systems are always up-to-date. In the world of IT, systems are consistently upgraded and patched and come with a slew of security protocols. It is a lot to handle, but your teams can handle this when implementing managed services.

The goal is to ensure your NetSuite instance supports your business’ growth.

For over 20 years, Etter+Ramli has helped several companies optimize their NetSuite software solution. With a 95% customer satisfaction rate, Etter+Ramli can provide your company with world-class support, Certified NetSuite experts, and a value-based pricing structure.

Etter+Ramli As Your Extended NetSuite Team

Etter+Ramli is an Independent Managed Success Provider for NetSuite clients. We are NOT partnered with Oracle NetSuite and do not take commissions. We bring our knowledge, expertise, and passion for success to our clients. We help clients Buy, Deploy, Grow, and Abandon NetSuite. We engage as a client-side managed service to ensure our priorities align with our clients.

To explore the benefits of retaining Etter+Ramli as your Managed Success Provider, contact Todd Kimpton or visit our website for a free consultation today.

Comentários


The company logo and brand name owned by EtterRamli image.

Etter+Ramli is a managed service provider that is focused on enabling NetSuite customers to get  more value from their investment.

  • icons8-linkedin-100
  • icons8-youtube-100

​​​Etter+Ramli Head Office

160 Robinson Road
#14-04 Singapore Business Federation Center
Singapore (068914)




Etter+Ramli Vietnam
 

No. 5 – TT22 TW Dang & Bao Nhan Dan complex - Trinh Van Bo Street – Xuan Phuong Commune - Nam Tu Liem District – Hanoi, Vietnam

Etter+Ramli US
 

205 Ken Pratt Boulevard
Suite 120, Longmont CO 80501

897 Albion Ave SE Ocean Shores

WA 98569 (Satellite office)

Etter+Ramli Australia

Level 1/1386 Toorak Rd,
Camberwell, Victoria, 3124

©2024 by Etter+Ramli LLP, Managed Success for NetSuite. 

bottom of page