Skip to content
+1-888-319-3663

EONE BLOG

SmartList Builder 2013 New Feature of the Day: Table Finder


There is a new Table Finder option that will be included in the January release of SmartList Builder 2013.  It will assist 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.  This can be really helpful if you know where the data is in a Microsoft Dynamics GP window, but aren’t sure where to look in the tables for the data so that you can use it in a setup in one of the Builder tools.

There are 3 methods that will be included that allow you to find the table:  those attached to a Dynamics GP window, by the field name, or by the value in the field.

Tables attached to a Microsoft Dynamics GP Window:
This option will allow you to see all of the tables that are used on a window in GP.  You can see all for the window, or if you pick a specific field, it will tell you what tables that field is in.

The window below is what you will see in any of the Builder tools when adding a new table and selecting to use the Table Finder.


The window following is what you will see if you select the Table Finder from any of the Microsoft Dynamics GP windows Tools menu.  It offers the ability to create a setup in SmartList Builder, Excel Report Builder, and Navigation List Builder with the table you have selected.  In addition to using it with the Builders, you can create sample select statements by selecting the fields you want from the selected table and preview that data.


Field Name:
This option allows you to type in a Field name as it appears on any window and it will find the tables that contain that field.  You can then select the table and see the details of that table.



 
Field Value:
The Field Value option will allow to search the data for any tables containing the data value you enter.  This option can take some time, depending on the amount of data in the Microsoft Dynamics GP company database, but can be useful if the field might be called different things on different windows.  You can also select the table and see the details of that table.







Leave a Comment





RECENT POSTS


2021 Q4 Promotions
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

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

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.