Skip to content


Look what’s coming to SmartList Builder

We are excited to announce the new features coming to SmartList Builder, Excel Report Builder, and Navigation List Builder in our January update for Microsoft Dynamics GP 2013.

Over the coming weeks, we will release more detail on each feature, but wanted to put together a list of the new features for everyone.  Please note that some features apply to all of the Builder modules, others only apply to one or two.

SmartList Builder New Features:
  1. Auto Updating SmartList:  If you have SmartList already open when you save a SmartList Builder setup, it will automatically update that SmartList.  No more having to close SmartList and saying yes to the message to update it if you already have it open.  If you don’t have it open when you save the SmartList Builder setup, it will still prompt you to update SmartList when you launch it.

  2. Modifying Existing SmartList:  You will be able to highlight any existing SmartList and click the Modify button in SmartList. This will open SmartList Builder and pull up that SmartList if it is one built in SmartList Builder.  If it is one of the default SmartLists that come with Microsoft Dynamics GP, it will pull in a setup of that default SmartList and allow you to modify it as needed.  The SmartList that it creates should function the same as the default one does.  Once the new setup is saved, it will hide the default SmartList and display the new modified one.

  3. Create New SmartList Builder setups from SmartList:  You will be able to click the New button in SmartList and have it open SmartList Builder directly so that you can create a new SmartList.

  4. Built in GoTo’s:  Along with being able to modify the existing SmartLists, there will be Built in GoTo’s that will function the same as the GoTo’s on the default SmartLists that you can add to your SmartList Builder setups.  You no longer have to set them up to mimic the default ones.

SmartList Builder and Navigation List Builder New Features:
  1. SQL Scripting:  Now you can choose the table type of SQL Script which will allow you to write a SQL Script directly in SmartList Builder to pull in the data you need.  You no longer have to go to SQL Management Studio and write a SQL View to pull into SmartList Builder.  You can just write it directly into SmartList Builder if you would like.

SmartList Builder, Navigation List Builder, and Excel Report Builder New Features:
  1. Preview Data:  In SmartList Builder, there will be an option to preview the data that would be returned by the SmartList.  This allows you to view the data to make sure you are getting what you would expect without having to update SmartList all the time and run it there.

  2. New Icons:  The icons have been changed to better indicate the type of table that has been added to the SmartList Builder setup.

    And my personal favorite…

  3. Table Finder:  There is a new Table Finder option that will help in finding the tables that contain the data you are looking for.  You can access the tool from within any of the Builders or from any other window in Microsoft Dynamics GP.  It will allow you to select down to the field level and then will tell you what table(s) that field is in so that you can find the data you are looking for without much effort.

1 Comment

  1. Lyn Barr on January 7, 2014 at 6:28 pm

    My personal favorite is sure to be the SQL scripting! I'm looking forward to downloading the new build and testing out these new features.

    Thanks for the update, Victoria!

Leave a Comment


Join Us in Chicago at the Zendesk Showcase!
Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!
What is a Data Lake/Data Lake Management?


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



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 Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.