DEX.ini

Dex.Ini Settings to Make Dynamics GP More Friendly

Posted on

DEX.INI: The Microsoft Dynamics GP defaults files which contain setup and operating information. Each setting contains information such as where files are located and whether certain functions are performed. It is stored on each computer where the Microsoft Dynamics GP application files are installed. The information in the file affects only the computer where the file is located. This file is also essential for Microsoft Dynamics GP to run correctly, so we have to be very careful when editing it. But at the same time, it can be a good advantage to explore its possibilities.

Below are some settings which can be used for troubleshooting Microsoft Dynamics GP problems or making work in Dynamics GP more comfortable. Some of them are default settings, but some of them are optional.

  • SQLLogSQLStmt=TRUE
    SQLLogODBCMessages=TRUE

    SQLLogAllODBCMessages=TRUE – Turn on all of these 3 settings and information is going to be appended to the end of the existing log DEXSQL.LOG file (or a new file is going to be created)
  • Synchronize = TRUE – Forces a synchronization of the chart of accounts format
  • OLEPath=\\server\folder\ole – Sets the path for linked and embedded files. This is often set up inconsistently in the initial setup. You'll need to include your path in place of the file:////server/folder/ole
  • SampleDateMsg=FALSE – Prevents the sample company dialog box from being displayed, but the date is still set on 04/12/2017
  • AutoInstallChunks=TRUE – Add CNK files without the "Add New Code?" dialogue after logging into Dynamics GP
  • WindowMax=TRUE – Open the Dynamics GP main window full screen
  • ScriptDebugger=TRUE – Turn Script Debugger Features on in Runtime Mode

There are also some other settings (which I haven’t used or checked), but maybe this list can help somebody else because I have found them to be very useful:

  • SuppressChangeDateDialog=TRUE – Turns off the Date Change dialogue that opens at midnight
  • NoPrintDialogs=TRUE – Suppress the print dialogue box
  • ShowResids=TRUE – Make resource ID's visible in Dexterity
  • ShowAdvancedMacroMenu=TRUE – Turn on the Advanced Macro Menu
  • C:\DPS1\DEX.INI DPSInstance=1
    C:\DPS2\DEX.INI DPSInstance=2
    C:\DPS3\DEX.INI DPSInstance=3
    – Run multiple process servers on a single machine. Specifics on CustomerSource here. (One line for each process server)
  • ExportOneLineBody=TRUE – Eliminate line wrapping when exporting reports to comma or tab delimited files.
  • IMPath=C:\Program Files\Microsoft\Great Plains\Integration Manager\IM.EXE IMExecPath=C:\Program Files\Microsoft\Great Plains\Integration Manager\IMRun.EXE – Set the path to Integration Manager so it will launch properly from the menu. (2 lines)
  • SampleDateMMDDYYYY=00000000 – Prevents the sample company dialogue box from displaying and sets the date to the current date.
  • SampleDateMMDDYYYY=MMDDYYYY – Prevents the sample company dialogue box from displaying and sets the sample company to the date defined. (5/1/08 would be 050102008).