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


eOne Office Hours: Popdock for Data Migrations
SmartConnect 21 Release
Popdock: May The Visualforce Be With You – Part I
Q4 2020 Partner All Hands Call - Recording Now Available!
2021 Popdock & SmartConnect Bootcamps

POPULAR POSTS


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

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.