Month: December 2009

Get Allocated Inventory Items in Microsoft Great Plains

Posted on

Below is the SQL query to get al the allocated inventory, copy and paste
the below code in sql browser on the GP company database. Modify accordingly
for the result.

PRINT ‘This is the allocated quantity in the SOP10200 for Orders’
select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC from SOP10200
where ITEMNMBR = ‘A’ and ATYALLOC > 0 and SOPTYPE = 2

PRINT ‘This is the allocated quantity in the SOP10200 for Invoices’
select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC from SOP10200
where ITEMNMBR = ‘A’ and ATYALLOC > 0 and SOPTYPE = 3

PRINT ‘This is the allocated quantity in the IV10001 for a decrease Adjustment’
select IVDOCNBR,ITEMNMBR,TRXQTY from IV10001
where ITEMNMBR = ‘A’ and TRXQTY < 0 PRINT ‘This is the allocated quantity in the IV10001 for Transfers’ select IVDOCNBR,ITEMNMBR,TRXQTY from IV10001 where ITEMNMBR = ‘A’ and TRXQTY > 0 and IVDOCTYP = 3

PRINT ‘This is the allocated quantity in the IVC10101 for saved Invoices’
select INVCNMBR,ITEMNMBR,QUANTITY from IVC10101
where ITEMNMBR = ‘A’ and DOCTYPE = 1

PRINT ‘This is the allocated quantity in the BM10300 ‘
select TRX_ID,ITEMNMBR,ATYALLOC from BM10300
where Component_ID <> 0 and ITEMNMBR = ‘A’
and ATYALLOC > 0

PRINT ‘This is the allocated quantity in the POP10500 for POP Returns’
select POPRCTNM,QTYRESERVED from POP10500
where QTYRESERVED > 0 and Status = 0 and ITEMNMBR = ‘A’

This entry was posted in GP.

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).

This entry was posted in DEX.ini.