Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In 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

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