EONE BLOG

Tech Tuesday: Using a NetSuite Saved Search


If you’ve already setup a NetSuite saved search, you can easily use it in SmartConnect to get that data out for an integration. To use a saved search in SmartConnect.com, you first need to have setup your NetSuite connector.

An article on that setup can be found here.

Creating a new Netsuite saved search for use in SmartConnect

  • In NetSuite, navigate to Reports>>Saved Searches>>All Saved Searches>>New
  • Select the search type for the type of records you need to use. In this example I will use Customer.
  • Set a Search Title. This how the search will appear in SmartConnect.
  • Add a filter to narrow down your data set. I set my criteria to only return customers from MN & ND.
netsuite saved search
  • Save the search setup.

For a saved search to be valid in Smartconnect.com, it has to return a list of data. Summarized searches will not work. Functions and custom labels will also be ignored at this time.

Setting Up a Saved Search Data Source in SmartConnect

  • Navigate to Data Sources>>Bulk Sources>>Query and click on Create Bulk Query.
  • Choose NetSuite Query.
  • Name your query, select your NetSuite connector, click Validate, and then choose Saved Search as the Query Type.
  • Select your search type. This is the same list that is used when you setup a new saved search in NetSuite, so select the same search type as when the saved search was created.
  • Choose the Saved search you would like to use as your data source.
  • Choose which columns you would like to make available in your data source and Save.
  • Preview the data to make sure you are getting data in the fields you need.

You can now use this NetSuite saved search data source on as many integration processes as you need. If you make any changes to the saved search in NetSuite, those changes will automatically be applied to the query data source in SmartConnect that is linked to the saved search.

If you have any more questions, feel free to reach out to us at sales@eonesolutions.com

Leave a Comment





RECENT POSTS


Employee Spotlight: Mary Charuhas, Partner Development Manager
Join us for the Q1 Partner All Hands Call!
SmartConnect Office Hours: Executing Maps Remotely
Partnering with eOne Solutions & Getting Started
2020 Q1 Promotions

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.