Skip to content


Convince My Boss: SmartList Builder

Everyone needs and uses SmartList in Microsoft Dynamics GP. Users quickly notice, however, that SmartList lacks all the functionality they require to produce the best report. Often there’s a need for more fields on the existing list or a different, separate list to get all the data required for the report. SmartList Builder can help. In fact, Microsoft Dynamics GP users consistently express that SmartList Builder is a tool they can’t live without.


While users are quick to realize that SmartList Builder is something they need, convincing their boss may be the next hurdle. There are so many reasons everyone should have SmartList Builder included in their Microsoft Dynamics GP environment. Let’s look at a few key features to highlight to the decision maker:


  1. Increased Productivity: SmartLists with the exact data needed increases a user’s productivity each day. Imagine not having to combine multiple SmartLists or other GP reports to get the needed data. There’s no longer a need to take a SmartList and drill back on data to find the detail. Just add the detail to a SmartList using SmartList Builder. For example, when using payables, seeing the general ledger distributions is something many people want, but they don’t want to have to drill down on each transaction. You can create a new SmartList in SmartList Builder to pull together the payables and general ledger into one list. Have 10 users utilizing SmartLists and piecing together reports? Imagine they each saved 30 minutes a day by using SmartList Builder to generate the lists they need. Get 25 hours back in a week simply by using a more robust tool.


  1. External Reporting. Excel Report Builder is a feature included in SmartList Builder. Everyone has waited for a SmartList to export to Excel to get the data where they need it. Many times, in that process, you find out that you forgot something and must go through the export again.  Excel Report Builder allows you to create the list in Excel and takes out the need to run it in SmartList and doing the export. Excel Report Builder reports will automatically refresh in Excel.  Any formatting you save in the Excel report will automatically be there every time you use the report. You can add Pivot Tables, Charts, Dashboards, etc. to the Excel report and have the data in these customizations refresh as well. This is going to save you a lot of time waiting for the export, as well as doing the formatting each time.


  1. Everything can be done by SmartList Builder users. There is no longer a need to involve the IT team in simple things like building or modifying a report. SmartList Builder is intuitive and gives users the ability to create and modify reports on your own. As a bonus, SmartList Builder even has a feature called Table Finder which assists users in finding the tables that contain the data you need. This eliminates the need to bring in an IT resource any time a user needs to know what table contains a specific field or window. Users can quickly find that information out on their own.


SmartList Builder can be installed in a few easy steps and be ready to use with minimal setup. It can be downloaded right from the eOne site can even be installed and used in Fabrikam, Inc. without registration keys so that you can try it out. It’s easy for users to get up to speed on through online, Self Paced Training which allows you to learn at your pace and get hands on experience with the features.


There are many reports that you will want to build in SmartList Builder – like reports that put a Summary Trial Balance in SmartList or allow you to view your account transactions with detail from their source such as project numbers. There are over 500 SmartList Builder templates already built to use in  SmartList Builder, Excel Report Builder, and Navigation List Builder for you to use live, modify to meet your needs, or learn from.



SmartList Builder is a tool that transforms the way users spend their time reporting in Microsoft Dynamics GP. It provides the most efficient way to build out report – saving users time and freeing up IT resources that would have normally been used to assist.


If you’d like to know more, sign up for a demo here.




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.