Skip to content


Tech Tuesday: Using Refresh Lists in SmartList Builder

This week’s Tech Tuesday is from our Quality Assurance, Jared Dux, highlights a commonly asked question about SmartList Builder. If your lists need to be refreshed be sure to read below:

The past couple weeks I’ve seen several cases where SmartList Builder needed to have lists refreshed. When a table or view has been updated in the database, Refresh List maintenance will need to be done for the SmartLists to take the new changes. This window can be found in Microsoft Dynamics GP-Tools-SmartList Builder-Maintenance-Refresh Lists.

Depending on the amount of changes that have been made in the database you have a couple options in this window. You can select lists individually in a case where you may have just added a new column to a custom table that will only effect one SmartList. If you made a lot of changes to tables that are used in a SmartList you can simply refresh all lists at once to save time. After processing the lists there are a few things to note.

1. Fields set to display by default will need to be re-checked in SmartList Builder when updated in the database.
2. Calculations will need to be updated if using fields that were updated in the database.
3. Restrictions will need to be updated if using fields that were updated in the database.
4. Key Fields will need to be re-selected if updated in the database. 

Refresh Lists can help save you time when tables or views have been modified in your database. Rather than creating a new SmartList setup, which I have seen several times, you can simply use this maintenance feature to automatically reflect the changes in your table/view in SmartList Builder.

Have questions about SmartList Builder? Email for more information!

1 Comment

  1. Hussain Ali Al Yousef on July 2, 2018 at 8:13 am

    Thank you very mcuh.

    You saved my time with this tip.

Leave a Comment


Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release
October 2021 Releases of Extender, SmartList Builder, SmartView, SmartPost, and Flexicoder are Now Available


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 Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SmartConnect 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.