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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In 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