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
bill colbert 9/27/2017 12:16:33 PM

Additional ASI_MSTR_Explorer... error

I am getting an error trying to build the SmartList files.

Dynamics GP 14.00.1059

SqlServer Express 2012

The attached ZIP file contains the ridiculously long Dexsql.log and a word document with the errors.

I was originally getting the ASI_MSTR_Explorer... error for columns don't match.  I ran the Drop and Create SQL Maintenance steps discussed in a different article found here.  Now I get this error when logging into Dynamics and trying to build the SmartList.

Thanks for any help


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