Microsoft Great Plains Established up Highlights

Latest edition of Microsoft Dynamics GP, 10.0 is available on Microsoft SQL Server 2005 and 2000. In the event you are on additional experienced version, we’ll also provide you advise on the place by to track down facts. We will start off with Microsoft Terrific Plains architecture and know-how inside of of:

one. Application Dictionary. Main dictionary is DYNAMICS.DIC, the dictionaries as well as their solutions and remedies are mentioned in Dynamics.founded file. These dictionaries are interpreted by Dex.exe software program. GP proprietary architecture is Microsoft Dexterity: Dex types, scientific studies, fields, string and also other objects similarly as Dex sanscript scripts are stored during the Dex dictionary. Regularly we have now this question asked for – what on earth is DEX_ROW_ID. The answer – this tends to be unique identifier, necessary by Terrific Plains Dexterity inner logic

two. Marriage to SQL Server. GP talks to MS SQL Server databases through ODBC marriage. In case you are on House windows sixty four tiny little bit procedure, on the minute you will should deploy 32 small bit ODBC DSN

3. SQL Server Databases. DYNAMICS is procedure database, which saved shoppers and protection, business definitions furthermore currencies and system-wide multicurrency options among the other treatment matters. Firm databases merchants options, learn information, perform, open up and historical transactions to get a human being legal entity – small business. Odds are you will install limitless quantity of corporations right now. SQL objects: tables, saved strategies and so-called atomic saved approaches (their names start with zdp_). GP would not use SQL referential integrity, “integrity” is programmed on organization logic degree

four. Set up technique. Initially GP starting copies GP particular person software with or with out SQL objects (SQL objects are demanded to load Dynamics and business database in the event you are executing new put in or initiate increase course of action if this can be definitely your purpose). You’re able to accomplish GP workstation preliminary installation to your server – this tends to enable you to load GP server facet a lot quicker, but this isn’t expected – you could possibly set up 1st workstation on Vista or XP equipment and cargo server side remotely. Any time you put in to get started on with GP workstation, Excellent Plains Utilities courses starts instantaneously to begin Server set up strategy

5. Supplemental GP merchandise: Activity Accounting, Preset Property, Manufacturing, Assortment Administration are outstanding illustrations – nearly each individual of those items has its have Dexterity dictionary file – you might discover its name by examining Dynamics.set file

six. Even further GP workstations set up. For conclude customers you do not place in SQL objects, in addition to GP Utilities synchronize Dynamics dictionary with GP database settings (GL account structure)

7. Customization install. If anyone did Amazing Plains Dexterity customizing yourself, they often provide you with so-called Dexterity chunk file, this file you copy into GP workstation folder and when you start Amazing Plains long run time, this chunk file are likely to be integrated (.cnk file will probably be reworked into Dex dictionary file and its doc will be further to Dynamics.founded file)