Skip to content


SmartList Builder Add SQL

rmcvicar asked 8 years ago
How to add "Add SQL Table" to Table option in SmartList Builder and Excel Report Builder? The "Add SQL Table options does not show when selecting plus ("+").

Best Answer
Jared answered 8 years ago
You will first need to grant security to the tables you want to use by going to Microsoft Dynamics GP-Tools-SmartList Builder-Security-SQL Table Security.  After you select the tables you want to get access to you should be able to add them in SmartList Builder.
Ron McVicar replied 8 years ago

Thank Jared This is resolved

If you would like to submit an answer or comment, please sign in to the eOne portal.