|
Microsoft Great Plains Installation Highlights Alba Spectrum
Current version of Microsoft Dynamics GP, 10.0 is available on Microsoft SQL Server 2005 and 2000. If you are on older version, well also give you advise on where to find information. Well begin with Microsoft Great Plains architecture and technology inside:
1. Application Dictionary. Core dictionary is DYNAMICS.DIC, the dictionaries and their products are listed in Dynamics.set file. These dictionaries are interpreted by Dex.exe application. GP proprietary architecture is Microsoft Dexterity: Dex forms, reports, fields, string and other objects as well as Dex sanscript scripts are stored in the Dex dictionary. Often we have this question asked what is DEX_ROW_ID. The answer this is unique identifier, required by Great Plains Dexterity internal logic
2. Connection to SQL Server. GP talks to MS SQL Server databases via ODBC connection. If you are on Windows 64 bit platform, at this time you will have to deploy 32 bit ODBC DSN
3. SQL Server Databases. DYNAMICS is system database, which stored users and security, company definitions plus currencies and system-wide multicurrency settings among other system things. Company database stores settings, master records, work, open and historical transactions for one legal entity company. You may install unlimited number of companies at this time. SQL objects: tables, stored procedures and so-called atomic stored procedures (their names begin with zdp_). GP doesnt use SQL referential integrity, integrity is programmed on business logic level
4. Installation process. First GP installing copies GP user application with or without SQL objects (SQL objects are required to load Dynamics and company database if you are doing fresh install or initiate upgrade process if this is your purpose). You can do GP workstation initial installation on the server this will allow you to load GP server side faster, but this is not required you can install first workstation on Vista or XP machine and load server side remotely. When you install first GP workstation, Great Plains Utilities applications starts automatically to begin Server installation process
5. Additional GP products: Project Accounting, Fixed Assets, Manufacturing, Collection Management are good examples each of these products has its own Dexterity dictionary file you can recognize its name by reviewing Dynamics.set file
6. Additional GP workstations install. For end users you do not install SQL objects, plus GP Utilities synchronize Dynamics dictionary with GP database settings (GL account format)
7. Customization install. If somebody did Great Plains Dexterity customizing for you, they typically provide you with so-called Dexterity chunk file, this file you copy into GP workstation folder and when you launch Great Plains next time, this chunk file will be integrated (.cnk file will be transformed into Dex dictionary file and its record will be added to Dynamics.set file)
8. Integration Manager installation. IM is currently under the process of being rewritten in eConnect (integration tool, which is written in SQL encrypted stored procedures with various interfaces to be exposed to BizTalk, Web Services, ADO.Net, etc), so if you will decide to install eConnect connector, you will need to specify your domain user account for eConnect security
9. Great Plains Software old versions installation notes. If you have Great Plains Dynamics 5.0, 5.5, 6.0, 7.0 or 7.5, these versions were available on Btrieve, later on purchased by Pervasive Software and renamed into Pervasive SQL 2000 and Ctree/Faircom. Pervasive/Btrieve Client-Server version requires altering for Pervasive SQL Server settings, so if you just need single user GP workstation for transactions lookup only, we recommend you to follow single user workstation installation instructions. Both Ctree and Btrieve versions have Location Translation technology, please give us a call on location translation as it is no longer supported by Microsoft Tech support and is not trivial in its consideration
10. Great Plains Accounting for DOS, MS Windows and Mac. This dinosaur support was terminated in around 2001, however there is migration path to Microsoft Dynamics GP, plus you should get discount on GP modules purchase. It is not practical to try GPA migration to GP on your own, we recommend you to have Great Plains technical consultant to do the migration job.
If you like us to help you with GP upgrade, integration, software licenses, reporting, please give us a call
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale
|
Company: Alba Spectrum Group
| Related press releases |
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
Old Great Plains Dynamics versions support, recovery and upgrade Alba Spectrum [2007-08-29 05:31:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 10630-961-5918
In best case scenario you as Microsoft Dynamics GP customer who is following the recommended ve...
|
|
Microsoft Dynamics GP 10.0 Business Portal installation notes Alba Spectrum [2007-08-09 04:56:35]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Business Portal is Microsoft Windows SharePoint 3.0 application and as such it also requires .N...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
Upgrading to Microsoft Great Plains 10.0 Alba Spectrum Chicago [2007-08-07 07:15:48]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP upgrade service in Chicagoland: downtown Chicago, Chicago Southwest subur...
|
|
eConnect eCommerce Posting Server for Dynamics GP Alba Spectrum [2007-09-22 02:52:59]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect Microsoft Dynami...
|
|
|
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
| QIOS Pelican |
 Use QIOS Pelican to send personalized, bulk or mass e-mail to contacts in data sources, such as Microsoft SQL Server, Exchange, Access, Outlook, Excel, Oracle or MySQL. Define fields in your message and apply the datasource to create the e-mail. |
|
| uCertify MCSE (70-270) practice test |
 Pass MCSE exam 70-270 in first attempt. 455 questions with detailed explanation and 138 study notes. 70-270 - Windows XP Professional study notes, articles and mock test. 99% pass rate, 100% money back guarantee. Based on latest Microsoft certificat |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| SnapaShot |
 Smallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button. |
|
| Dutch Duck Cache and History Reader |
 Dutch Duck Cache and History Reader shows Microsoft Internet Explorer's History, Cache, Cookies, and Favorites in a very accessible, spreadsheet-like format. You can selectively remove items, and sort, group, search, print, and export everything. |
|
|
Latest press releases
