How to Set Up NetSuite Saved Search with Age in Days Function

Setting date results to Function Age in (Days, Months, or Years) can be very beneficial to anyone in need of results filtered in days, months or years in the past. Age in Days Function can be added to ANY date field. A great example of this feature is setting a saved search as a Custom Search Portlet on your dashboard and using a “Transaction” saved search with “Age in Days” on the Last Sales Order Date Results. Highlighting can then be used to add priority. This will allow you to track Customer Sales on the dashboard that could otherwise be forgotten.

Age in Days Function - Dashboard View

Age in Days Function – Dashboard View

Create the Saved Search

    1. Create a Saved Search
      In our example, we create a transaction saved search to check customers last sales order date.

      Create a Saved Search

      Create a Saved Search

 

    1. Configure your Transaction Search Filters
      We are looking for all Sales Orders generated
      before YESTERDAY.

      Configure your Transaction Search Filters

      Configure your Transaction Search Filters

 

    1. Configure your Transaction Search Result
      We are using Age in Days function against Date of Last Order field. You can apply this function against any date field depending on the purpose of your search

      Configure your transaction search result

      Configure your Transaction Search Result

 

  1. Add (Summary) Highlighting:
    Make sure to select “Highlight if…(Summary)” when you want to highlight Grouped Results.
    We are highlighting all customers who haven’t ordered in 3 months in Yellow and all customer who have ordered within 3 months in Green.

    Configure Saved Search Highlight if…(Summary)

    Highlight if…(Summary)

 

Create the Dashboard Portlet

    1. Add a Custom Search Portlet:
      We add a Custom Search Portlet to display the results of our search on our home dashboard.

      NetSuite Personalize dashboard

      NetSuite Personalize dashboard

 

  1. Configure the Portlet:
    Under “Search” we choose the Saved Search we want to be displayed in the portlet

    Configure the Portlet

    Configure the Portlet

Extended Functionality:

  1. Age in Days can be used in any saved search to apply similar functionality.
  2. Inventory Items that are out of stock can be sorted by Age in Days to give priority
  3. Highlighting can be applied to high priority Customers who haven’t ordered in X amount of days, months, or years.

These type of reports are quick to build and easily deployed to management team. Do you need complex reports built? or improve existing ones? Give us a call!

About Abaci
Abaci is a premier NetSuite Solution Provider with deep knowledge in both business process and technology architecture. Our team is passionate about NetSuite and has an exclusive commitment to NetSuite and to providing the highest level of system expertise on its full suite of cloud-based business management applications.