DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
kkoehle@valuedrugco.com 9/7/2017 7:05:15 AM

GP Smartlist Builder - access to SQL tables and views

I am creating a new Smartlist in GP, and I want to use a new SQL view and table.

Both the view and table are in the same database where my other GP tables are located, yet they do not show up in the list of tables or views that are available when I try to select a table for the Smartlist. 

I'm assuming this is a permissions issue - with me as a user or the table and view?

 

Version: GP 2015
Section: Dynamics GP