Great Plains Dexterity Dynamics eEnterprise Microsoft CRM Microsoft RMS Crystal Reports SQL International
Phones
Toll Free: 1-866-528-0577
Office: 1-630-961-5918
Cell (consultant-on-duty): 1-630-854-0597
Email: welcome@albaspectrum.com.
Alba Spectrum Technologies
Some Great Plains Common Technical Questions
Q. How to unlock user in Great Plains?
A. On SQL platform: login as sa and in system->user activity->delete user. Alternative: in SQL Query Analyzer issue delete activity where userid='user1' / here replace user1 with real user id. This statement should be ran against DYNAMICS database
Q. How to find Great Plains tables structure?
A. Login to Great Plains, go to Tools->Resource Description->Tables. Tables are grouped by series (Financial, Sales, etc.). Great Plains logic groups physical tables into logical tables, for example Customer Master logical tables group has Customer Master table (RM00101), Customer Address Master table (RM00102), etc
Q. How to unlock the Batch in Great Plains?
A. You can use batch recovery from Routines, but it doesn't work all the time. The other way is to do surgery in SQL Query Analyzer on COMPANY.SY00500 (Batch header table) and some times DYNAMICS.SY00800 (batch activity table)
Q. How to enable custom application, which supposed to replace original Great Plains form?
A. You need security for the user or user class to be enabled to use so-called Alternative Great Plains windows setup->system->security. In this window you enable custom reports, modified forms (they are modified via Great Plains Modifier)
Q. How to "repair" Great Plains data on Pervasive SQL or CTree platform
A. We recommend Microsoft Access linked tables. You need also to install proper ODBC drivers from Great Plains CDs