kkoehle@valuedrugco.com 1/30/2019 3:28:01 PM

SQL tables and Smartlist Builder from DYNAMICS database

I am trying to create a new Smartlist in GP using SQL tables from the DYNAMICS database.   Most of our other Smartlists use tables from a different database that houses a lot of our GP data, but the tables I want to use are in DYNAMICS for this one. 

When I go into Smartlist Builder and try to add a SQL Table, when I choose the DYNAMICS Database, there are no tables listed for it to choose from.

I think this is a security/permissions problem with DYNAMICS? 

 

 

Version: GP 2015
Section: Dynamics GP


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3