1. Outlook hangs during initialization (progress toolbar displays “Loading…” and never finishes)
This must-have fix is likely the most common perf/stability issue out there, especially on Outlook 2007. This fix resolves the issue. A current workaround exists by turning off the To Do bar.
http://support.microsoft.com/kb/952724 (not yet published, but fix available from support)
2. With E-mail Auto Promotion Enabled, Outlook may not close cleanly/properly.
This fix addresses a memory allocation issue that can occur somewhat unpredictably. If your users are using e-mail auto promotion, I encourage you to deploy this hotfix.
http://support.microsoft.com/kb/948121
3. Contacts with birthdays earlier than 1/1/1970 causes Outlook to crash
This was caused by an API change by one of our dependencies.
http://support.microsoft.com/kb/948045
4. Hoster process can crash on startup of CRM for Outlook with Offline Access (Laptop Client)
This fix addresses a memory allocation issue that occurs rarely, but worth checking out if your hoster process inexplicably crashes.
http://support.microsoft.com/kb/951884
5. Items in Shared Calendars will report Sync Issues
We do not support Shared Calendars in CRM 4.0, we encountered a couple of cases where some code was getting executed against a shared calendar and causing problems.
http://support.microsoft.com/kb/949086
6. Appointment attendees do not resolve properly
This problem occurs when you set to option to only “Match against contacts synchronized to Microsoft Dynamics CRM.”
http://support.microsoft.com/kb/949141
7. Unable to Go Offline with a MUI pack installed
This fix resolves a parsing error that occasionally appears in the Go Offline process, causing a failure.
http://support.microsoft.com/kb/951179
8. Changing CRM website port after re-configuring IIS
We’ve encountered some customers who have made changes to the CRM IIS configuration after installation (such as adding host headers) and then had trouble with configuring clients. This is because certain config values are stored during setup which become invalidated after these IIS changes. The KB article below talks to this issue.
http://support.microsoft.com/kb/947423/
Wednesday, August 6, 2008
Microsoft CRM Outlook client and authentication balloons
Regkey Name Default
Description
ClientAuthNotificationThrottle 30000 Specifies the required elapsed time before which another balloon notification may be displayed (helps prevent too frequent balloon notifications).
ClientAuthRenewPeriod
60000
Specifies how frequently the hoster process will check if it should renew authentication.
ClientAuthVerifyConnectionPeriod
30000
Specifies how frequently the hoster process will check connectivity to the web application by downloading a tiny icon (anonymous access).
ClientAuthVerifySignedInPeriod
5000
Specifies how frequently the hoster process will check if authentication has been lost (ex: detect if cookies have been deleted or the CRM ticket has expired).
ClientAuthAllowRetries
3 Specifies the number of failed authentication attempts (after this an error will be shown or the client will move to the offline state).
Description
ClientAuthNotificationThrottle 30000 Specifies the required elapsed time before which another balloon notification may be displayed (helps prevent too frequent balloon notifications).
ClientAuthRenewPeriod
60000
Specifies how frequently the hoster process will check if it should renew authentication.
ClientAuthVerifyConnectionPeriod
30000
Specifies how frequently the hoster process will check connectivity to the web application by downloading a tiny icon (anonymous access).
ClientAuthVerifySignedInPeriod
5000
Specifies how frequently the hoster process will check if authentication has been lost (ex: detect if cookies have been deleted or the CRM ticket has expired).
ClientAuthAllowRetries
3 Specifies the number of failed authentication attempts (after this an error will be shown or the client will move to the offline state).
GP Customer Balance
SELECT distinct(T143.DOCNUMBR) AS Doc_No,T141.CUSTNMBR AS Customer_ID, T143.DOCDATE AS Doc_Date,T141.SLPRSNID, T143.POSTDATE AS Posting_Date,
CASE WHEN RMDTYPAL = 8 OR RMDTYPAL = 9 OR RMDTYPAL = 7 THEN CAST(T143.CURTRXAM * - 1 AS NUMERIC(19, 5)) ELSE CAST(T143.CURTRXAM * 1 AS NUMERIC(19, 5)) END AS AMOUNT,
T143.CURNCYID AS Curr_ID, T143.BCHSOURC AS Doc_Type FROM RM00101 AS T141 LEFT OUTER JOIN RM20101 AS T143 ON T141.CUSTNMBR = T143.CUSTNMBR AND T143.RMDTYPAL <> 6 AND T143.RMDTYPAL <> 2 AND
T143.VOIDSTTS = 0 LEFT OUTER JOIN RM20201 AS T150 ON T143.RMDTYPAL = T150.APTODCTY AND T143.DOCNUMBR = T150.APTODCNM LEFT OUTER JOIN RM00103 AS T161 ON T141.CUSTNMBR = T161.CUSTNMBR
WHERE (T143.RMDTYPAL <> 6 OR T143.RMDTYPAL IS NULL) AND (T143.RMDTYPAL <> 2 OR T143.RMDTYPAL IS NULL) AND (T143.VOIDSTTS = 0 OR T143.VOIDSTTS IS NULL) AND
(T143.CURTRXAM <> 0) ORDER BY T143.DOCNUMBR,Customer_ID
CASE WHEN RMDTYPAL = 8 OR RMDTYPAL = 9 OR RMDTYPAL = 7 THEN CAST(T143.CURTRXAM * - 1 AS NUMERIC(19, 5)) ELSE CAST(T143.CURTRXAM * 1 AS NUMERIC(19, 5)) END AS AMOUNT,
T143.CURNCYID AS Curr_ID, T143.BCHSOURC AS Doc_Type FROM RM00101 AS T141 LEFT OUTER JOIN RM20101 AS T143 ON T141.CUSTNMBR = T143.CUSTNMBR AND T143.RMDTYPAL <> 6 AND T143.RMDTYPAL <> 2 AND
T143.VOIDSTTS = 0 LEFT OUTER JOIN RM20201 AS T150 ON T143.RMDTYPAL = T150.APTODCTY AND T143.DOCNUMBR = T150.APTODCNM LEFT OUTER JOIN RM00103 AS T161 ON T141.CUSTNMBR = T161.CUSTNMBR
WHERE (T143.RMDTYPAL <> 6 OR T143.RMDTYPAL IS NULL) AND (T143.RMDTYPAL <> 2 OR T143.RMDTYPAL IS NULL) AND (T143.VOIDSTTS = 0 OR T143.VOIDSTTS IS NULL) AND
(T143.CURTRXAM <> 0) ORDER BY T143.DOCNUMBR,Customer_ID
GP Total invoiced quantity per item, per customer
SELECT
m.CUSTNMBR, d.ITEMNMBR,
d.ITEMDESC, SUM(d.QUANTITY) AS 'Total_QTY'
FROM SOP30200 m
inner Join SOP30300 d on m.SOPNUMBE = d.SOPNUMBE
WHERE Year(m.docdate) = 2007 AND m.SOPTYPE = 3
GROUP BY
m.CUSTNMBR, d.ITEMNMBR, d.ITEMDESC
m.CUSTNMBR, d.ITEMNMBR,
d.ITEMDESC, SUM(d.QUANTITY) AS 'Total_QTY'
FROM SOP30200 m
inner Join SOP30300 d on m.SOPNUMBE = d.SOPNUMBE
WHERE Year(m.docdate) = 2007 AND m.SOPTYPE = 3
GROUP BY
m.CUSTNMBR, d.ITEMNMBR, d.ITEMDESC
GP Show the earnings of each product with comparative sales performance from previous year
Declare
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@PreviousYear_StartDate As DateTime,
@PreviousYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As Int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
set @PreviousYear_StartDate = DateAdd(year,-1, @CurrentYear_StartDate)
set @PreviousYear_EndDate = DateAdd(year,-1, @CurrentYear_EndDate)
Select ITEMNMBR, ITEMDESC, Sum(PreviousYear_Sales) As PreviousYear_Sales, Sum(CurrentYear_Sales) As CurrentYear_Sales,
Sum(CurrentYear_Sales) - Sum(PreviousYear_Sales) As Variance
From
(
Select ITEMNMBR, ITEMDESC, PreviousYear_Sales=0, Sum(XTNDPRCE) As CurrentYear_Sales
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and m.SOPType=3 and voidstts=0
Group By ITEMNMBR, ITEMDESC
UNION
Select ITEMNMBR, ITEMDESC, Sum(XTNDPRCE) As PreviousYear_Sales, CurrentYear_Sales=0
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where DocDate >= @PreviousYear_StartDate and DocDate <= @PreviousYear_EndDate and m.SOPType=3 and voidstts=0
Group By ITEMNMBR, ITEMDESC
) As Table_Union
Group By ITEMNMBR, ITEMDESC
Order by CurrentYear_Sales DESC
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@PreviousYear_StartDate As DateTime,
@PreviousYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As Int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
set @PreviousYear_StartDate = DateAdd(year,-1, @CurrentYear_StartDate)
set @PreviousYear_EndDate = DateAdd(year,-1, @CurrentYear_EndDate)
Select ITEMNMBR, ITEMDESC, Sum(PreviousYear_Sales) As PreviousYear_Sales, Sum(CurrentYear_Sales) As CurrentYear_Sales,
Sum(CurrentYear_Sales) - Sum(PreviousYear_Sales) As Variance
From
(
Select ITEMNMBR, ITEMDESC, PreviousYear_Sales=0, Sum(XTNDPRCE) As CurrentYear_Sales
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and m.SOPType=3 and voidstts=0
Group By ITEMNMBR, ITEMDESC
UNION
Select ITEMNMBR, ITEMDESC, Sum(XTNDPRCE) As PreviousYear_Sales, CurrentYear_Sales=0
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where DocDate >= @PreviousYear_StartDate and DocDate <= @PreviousYear_EndDate and m.SOPType=3 and voidstts=0
Group By ITEMNMBR, ITEMDESC
) As Table_Union
Group By ITEMNMBR, ITEMDESC
Order by CurrentYear_Sales DESC
GP current year sales of each product in inventory
Declare
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
Select ITEMNMBR, ITEMDESC, sum(XTNDPRCE) As CurrentYear_Sales
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where m.DocDate >= @CurrentYear_StartDate and m.DocDate <= @CurrentYear_EndDate and m.voidstts=0
Group by ITEMNMBR, ITEMDESC
Order by CurrentYear_Sales DESC
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
Select ITEMNMBR, ITEMDESC, sum(XTNDPRCE) As CurrentYear_Sales
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where m.DocDate >= @CurrentYear_StartDate and m.DocDate <= @CurrentYear_EndDate and m.voidstts=0
Group by ITEMNMBR, ITEMDESC
Order by CurrentYear_Sales DESC
GP invoice year total of each customer between the current and previous year
Declare
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@PreviousYear_StartDate As DateTime,
@PreviousYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As Int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
set @PreviousYear_StartDate = DateAdd(year,-1, @CurrentYear_StartDate)
set @PreviousYear_EndDate = DateAdd(year,-1, @CurrentYear_EndDate)
Select Custnmbr, Custname, Sum(PreviousYear_Invoice) As PreviousYear_Invoice, Sum(CurrentYear_Invoice) As CurrentYear_Invoice,
Sum(CurrentYear_Invoice) - Sum(PreviousYear_Invoice) As Variance
From
(
Select Custnmbr, Custname, PreviousYear_Invoice=0, Sum(Docamnt) As CurrentYear_Invoice
From sop30200 c
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and SOPType=3 and voidstts=0
Group By Custnmbr, Custname
UNION
Select Custnmbr, Custname, Sum(Docamnt) As PreviousYear_Invoice, CurrentYear_Invoice=0
From sop30200 c
Where DocDate >= @PreviousYear_StartDate and DocDate <= @PreviousYear_EndDate and SOPType=3 and voidstts=0
Group By Custnmbr, Custname
) As Table_Union
Group By Custnmbr, Custname
Order By Custname
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@PreviousYear_StartDate As DateTime,
@PreviousYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As Int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
set @PreviousYear_StartDate = DateAdd(year,-1, @CurrentYear_StartDate)
set @PreviousYear_EndDate = DateAdd(year,-1, @CurrentYear_EndDate)
Select Custnmbr, Custname, Sum(PreviousYear_Invoice) As PreviousYear_Invoice, Sum(CurrentYear_Invoice) As CurrentYear_Invoice,
Sum(CurrentYear_Invoice) - Sum(PreviousYear_Invoice) As Variance
From
(
Select Custnmbr, Custname, PreviousYear_Invoice=0, Sum(Docamnt) As CurrentYear_Invoice
From sop30200 c
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and SOPType=3 and voidstts=0
Group By Custnmbr, Custname
UNION
Select Custnmbr, Custname, Sum(Docamnt) As PreviousYear_Invoice, CurrentYear_Invoice=0
From sop30200 c
Where DocDate >= @PreviousYear_StartDate and DocDate <= @PreviousYear_EndDate and SOPType=3 and voidstts=0
Group By Custnmbr, Custname
) As Table_Union
Group By Custnmbr, Custname
Order By Custname
GP Invoice Summary
Declare
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
Select custnmbr, custname, sum(Docamnt) As CurrentYear_Invoice
From sop30200 c
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and SOPType=3 and Voidstts=0
Group By Custnmbr, Custname
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
Select custnmbr, custname, sum(Docamnt) As CurrentYear_Invoice
From sop30200 c
Where DocDate >= @CurrentYear_StartDate and DocDate <= @CurrentYear_EndDate and SOPType=3 and Voidstts=0
Group By Custnmbr, Custname
Cust History
declare @custnmbr as varchar(22)
set @custnmbr = 'CUSTOMER-ID'
select CUSTNMBR, DOCDATE as TrnDate,
case SOPTYPE
when 1 then 'Quote'
when 2 then 'Order'
when 3 then 'Invoice'
when 4 then 'Return'
when 5 then 'Backorder'
when 6 then 'Fulfillment'
end as Document,
SOPNUMBE as DocumentNo
from SOP30200
where CUSTNMBR = @custnmbr
and VOIDSTTS = 0
order by DOCDATE
set @custnmbr = 'CUSTOMER-ID'
select CUSTNMBR, DOCDATE as TrnDate,
case SOPTYPE
when 1 then 'Quote'
when 2 then 'Order'
when 3 then 'Invoice'
when 4 then 'Return'
when 5 then 'Backorder'
when 6 then 'Fulfillment'
end as Document,
SOPNUMBE as DocumentNo
from SOP30200
where CUSTNMBR = @custnmbr
and VOIDSTTS = 0
order by DOCDATE
orders due
Declare
@days as int
set @days = 5
select a.sopnumbe, a.docdate, a.ReqShipdate, datediff(day, getdate(), a.ReqShipdate) as days_left
from sop10100 a
where a.soptype = 2 and a.voidstts = 0
and datediff(day, getdate(), a.ReqShipdate) >= (0 - @days) and datediff(day, getdate(), a.ReqShipdate) <= @days
and not exists
(
select b.* from sop10200 b where b.sopnumbe = a.sopnumbe and b.soptype = 2 and b.qtyfulfi > 0
)
@days as int
set @days = 5
select a.sopnumbe, a.docdate, a.ReqShipdate, datediff(day, getdate(), a.ReqShipdate) as days_left
from sop10100 a
where a.soptype = 2 and a.voidstts = 0
and datediff(day, getdate(), a.ReqShipdate) >= (0 - @days) and datediff(day, getdate(), a.ReqShipdate) <= @days
and not exists
(
select b.* from sop10200 b where b.sopnumbe = a.sopnumbe and b.soptype = 2 and b.qtyfulfi > 0
)
GRANT ALL USERS
------------------------------------------------------------
-- SQL SCRIPT TO GRANT ALL USERS UNDER DYNGRP GROUP
-- ACCESS PRIVILEDGES TO ALL TABLES AND STORED PROCEDURES
-- RUN THIS SCRIPT UNDER A SELECTED COMPANY DB IN DYNAMICS.
------------------------------------------------------------
DECLARE @SQL_CMD VARCHAR(255)
DECLARE SQL_CURSOR CURSOR
FOR SELECT 'GRANT SELECT,UPDATE,INSERT,DELETE
ON [' + CONVERT(VARCHAR(64),NAME) + '] TO DYNGRP'
FROM SYSOBJECTS
WHERE (TYPE = 'U' OR TYPE = 'V') AND UID = 1
SET NOCOUNT ON
OPEN SQL_CURSOR
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC (@SQL_CMD)
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
END
DEALLOCATE SQL_CURSOR
DECLARE SQL_CURSOR CURSOR
FOR SELECT 'GRANT EXECUTE ON [' + CONVERT(VARCHAR(64),NAME) + '] TO DYNGRP'
FROM SYSOBJECTS
WHERE TYPE = 'P'
SET NOCOUNT ON
OPEN SQL_CURSOR
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC (@SQL_CMD)
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
END
DEALLOCATE SQL_CURSOR
-- SQL SCRIPT TO GRANT ALL USERS UNDER DYNGRP GROUP
-- ACCESS PRIVILEDGES TO ALL TABLES AND STORED PROCEDURES
-- RUN THIS SCRIPT UNDER A SELECTED COMPANY DB IN DYNAMICS.
------------------------------------------------------------
DECLARE @SQL_CMD VARCHAR(255)
DECLARE SQL_CURSOR CURSOR
FOR SELECT 'GRANT SELECT,UPDATE,INSERT,DELETE
ON [' + CONVERT(VARCHAR(64),NAME) + '] TO DYNGRP'
FROM SYSOBJECTS
WHERE (TYPE = 'U' OR TYPE = 'V') AND UID = 1
SET NOCOUNT ON
OPEN SQL_CURSOR
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC (@SQL_CMD)
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
END
DEALLOCATE SQL_CURSOR
DECLARE SQL_CURSOR CURSOR
FOR SELECT 'GRANT EXECUTE ON [' + CONVERT(VARCHAR(64),NAME) + '] TO DYNGRP'
FROM SYSOBJECTS
WHERE TYPE = 'P'
SET NOCOUNT ON
OPEN SQL_CURSOR
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC (@SQL_CMD)
FETCH NEXT FROM SQL_CURSOR INTO @SQL_CMD
END
DEALLOCATE SQL_CURSOR
more dex.ini
SuppressChangeDateDialog=TRUE - Turns off the Date Change dialogue that opens at midnight
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 file:////server/folder/ole
NoPrintDialogs=TRUE - Suppress the print dialogue box
ShowResids=TRUE - Make resource ID's visible in Dexterity
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE - Turn on Dex SQL Logging (all 3 lines)
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)
AutoInstallChunks=TRUE - Add CNK files without the "Add New Code?" dialogue
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)
WindowMax=TRUE - Open the GP main window full screen
SampleDateMsg=FALSE - prevents the sample company dialog box from being displayed
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).
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 file:////server/folder/ole
NoPrintDialogs=TRUE - Suppress the print dialogue box
ShowResids=TRUE - Make resource ID's visible in Dexterity
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE - Turn on Dex SQL Logging (all 3 lines)
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)
AutoInstallChunks=TRUE - Add CNK files without the "Add New Code?" dialogue
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)
WindowMax=TRUE - Open the GP main window full screen
SampleDateMsg=FALSE - prevents the sample company dialog box from being displayed
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).
Tuesday, August 5, 2008
GP 10 dex.ini settings
Below are settings that can be used to change the behavior of Dexterity, Great Plains; or both, add them to the DEX.INI file in the directory where Great Plains and/or Dexterity is installed.
| INI Setting | GP or Dex | Description |
| ADCProcessor=TRUE | GP | You will see this line in the Dex.ini file if you are using Manufacturing and have the checkbox marked in ADC Preferences. |
AdvLookups=FALSE | GP | New Users created will NOT be granted access to the Alternate lookup windows in the SmartList dictionary and will instead be assigned the old ‘green bar’ lookup windows. |
| AllowWrongDex=TRUE | GP | Will allow Dynamics GP to run with mix-matched versions of dexterity. DANGER |
| ApplicationName=name | GP | Changes the name the runtime engine displays when it is launched. Without this setting the name “Dexterity Runtime” is displayed. |
| AutoDisplayUpdate=TRUE | GP | Automatically redisplays the process monitor queue. |
| AutoInstallChunks=TRUE | GP | Causes Dynamics to automatically include the *.cnk file not prompting the user for 'Add New Code' during launch. |
| BTInterface=NoLoad | GP | This applied to the old Btrieve file handler (PSQL 2000) as to whether the interface would load when Dynamics was launched. |
| Buildphantom=TRUE | GP | Allows creation of a Manufacturing Order for a Finished Good Phantom Item. |
| BuildSQLMessages=TRUE | GP | This one will copy the Dexterity messages to a SQL table on next login and then it will set it back to FALSE. Once in a SQL table the messages can be used in stored procedures. The table is DYNAMICS.dbo.MESSAGES |
| DebugFonts=TRUE | GP & Dex | This setting causes Dexterity to generate a trace file named "debuglog.txt". This file lists the fonts that were considered and why particular fonts were chosen or rejected. |
| DebugUnknownFile=TRUE | GP & Dex | Returns a Btrieve or Ctree error code to help track problems with table errors. |
| DexHelpPath=pathname | GP & Dex | Path to Dexterity help files. |
| Dictionary Version=10.00.1061 | GP | The current version of the Dynamics.dic file. |
| DISALLOWSNLOTAOF=TRUE | GP | Prevents users from being able to "create" new lot numbers or serial numbers while transferring an item from one site to another. |
| DisplayTableErrors=TRUE, ALL or OPEN | GP & Dex | To display an ID for an unknown table error when the Dexterity Database Management Subsystem encounters one. The ID that's displayed can be used to determine the cause of the error. TRUE – Displays only unknown errors. ALL – Displays all table errors except the two most common: “duplicate” and “not found”. OPEN - Displays all table errors for an open operation. |
| DPSInstance=1 | GP | Tells the engine which instance of the Dynamics Process Server to use. |
| DynHelpPath=pathname | GP & Dex | Path to Dynamics help files. |
| EmpLookup=2 | GP | Causes the Employee Lookup to default to Last Name |
| EmpLookup=3 | GP | Causes the Employee Lookup to default to First Name |
| EmpLookup=4 | GP | Causes the Employee Lookup to default to Social Security Number |
| ExplorerFormatCurrency=FALSE | GP | Exports foreign currency (ie £ ) to Excel from SmartLists as numbers instead of text. |
| ExportOneLineBody=TRUE | GP | All fields and text entered in the body of the report will export to a single line when the report is printed to a file. Allows you to enter many fields vertically instead of having to enter them horizontally in the report layout. |
| FHCheckRanges =TRUE | GP & Dex | This setting specifies whether to log the instances when Dexterity decides which type of range to use for tables that use the SQL database type. The log will list all instances when Dexterity detected a range that was not “well-behaved” and whether Dexterity used an exclusive or inclusive range. The FHRANGE.LOG text file to be generated in the same location as Dexterity or the runtime engine. |
| FileHandler=SQL | GP | This use to be the DatabaseType and was used to determine in part what kind of tables to create when Ctree and Btrieve (PSQL 2000) were supported. |
| FLEXICODER_UPDATE_SEGMENTS=FALSE | GP | If using the Flexicoder product from eOne Solutions, this sets ? |
| FormDictionaryPath=pathname | GP10 | |
| HideInvisibleLayoutFields=FALSE | GP | Indicates whether the invisible window fields should be displayed in the Modifier. |
| IdleLoopValue= number | Dex | A numeric value that represents a setting to control how background tasks interface with the CPU. |
| IdleLoopValue=0 | Dex | Voluntarily give up the CPU when sitting idle and allow background processes to execute only as often as the OS issues a timer event. Under this setting, the runtime asks to be notified every 50 milliseconds or 20 times a second. Using this setting will cause some processes to be slower than in previous releases, but it will not allow the CPU to be pegged at 100% utilization. |
| IdleLoopValue=-1 | Dex | Use as much time as possible to execute background processes. Under this scenario, the CPU would never voluntarily be given up to other applications when sitting idle. This is the default setting and would cause the runtime to behave the same way as it has in previous versions of the Dexterity runtime. |
| IdleLoopValue=some positive number [maximum 500] | Dex | This value is interpreted as the number of times to process a part of a background task before voluntarily giving up the CPU. This can somewhat control the amount of CPU utilization taken up by background tasks. A typical range for the IdleLoopValue when setting it to a positive number would be between 5 and 10. Generally, you would never go above 200, even though the maximum is 500. |
| Initial=FALSE | GP | This line is associated with the automatic creation of palettes; it was used only Release 1 of Dynamics. It will default as equal to FALSE. |
| LastTaxCodeUpdate=02/28/2008 | GP | The date of the last payroll tax code update. |
| LastYearEndUpdate=11/14/2007 | GP | The date of the last payroll year-end update. |
| LayoutLayout1=162,20,833,616 LayoutToolbox=1,1,156,382 LayoutPropertiesSheetTab=1 LayoutPropertiesSheet=940,63,270,349 LayoutPropertiesSheetVisible=FALSE LayoutLayout2=169,28,615,391 | GP & Dex | Used to save the adjusted window size of the Layout window within Report Writer. |
| MagnifyScreenOutput=100 | GP | When a report is printed to the screen, this is the magnification setting. |
| MaxSWScrollbarSize=XXX | Dex | To allow the scrollbars to get bigger than 25. |
MFGRollupPhantomLabor = TRUE | GP | To roll costs on Phantom Bills of Material in MFG |
MinPMCheck=50.00 | GP | Used in conjunction with PSTL free tool to set the minimum payables check amount. This is used in conjunction with the Select Checks feature. No check for under the amount specified will be created. In this example the minimum check would be $50.00 |
| NextEntryID= | GP | |
| NextGroupID= | GP | |
| NoPrintDialogs=TRUE | GP | Print Dialog boxes will not appear. |
| NoteWindow=37,37,450,299 | GP | Used to save the adjusted window size of the Record Notes Window. |
| OLEPath=pathname | GP | Used to indicate where OLE objects that are attached to Dynamics notes should be stored. This must be a mapped drive, UNC will not work. |
| OLEPathHR=pathname | GP | Used to indicate where OLE objects attached to notes in the HR module are stored. This must be a mapped drive, UNC will not work. |
| PAPRINTFEESBEFORECC=TRUE | GP | Will cause fees to print before the cost categories on a Project Accounting invoice |
| Pathname=DYNAMICS/dbo/ | GP | Location of the Pathnames table (SY02100). When Ctree and Btrieve (PSQL 2000) were supported this line contained a path with either a drive mapping or UNC path to the Dynamics data directory. Today this setting points to the database containing the SY02100 table. |
| PrintReportDefinitionOptions=2 | GP & Dex | Indicates which of the six checkboxes are checked in Report Writer when the ‘Print Definitions’ button is selected. The value is the sum of each checkbox that is checked. The six checkboxes and their values include: 1 = General Information 2 = Calculated Fields 4 = Table Relationships 8 = Sort Segments 16 = Restrictions 32 = Layout Information If only General Information and Sort Segments should be printed the value here would be 9. |
| QueueMoreInfo=TRUE | GP |
Adds a More Info button to the Process Monitor window which displays the window above when selected. |
| Remove any ST_ lines that appear in the file. | GP | Stops named printers from being used on a workstation. |
| Remove the setting: SQLCursorBlockSize=100 | Dex | To prevent the |
| ReportDictionaryPath=pathname | GP10 | |
| ReportLayout=158,155,814,617 | GP | Used to save the adjusted window size of the Layout window within Report Writer. |
| ReportViewMode=1 | | |
| REVALUEINDETAIL=TRUE | GP | Inventory cost adjustments will flow into the general ledger in detail instead of the default behavior which is to create a single summarized journal entry. |
| RuntimeAsserts =TRUE | GP & Dex | Forces the runtime engine to display a dialog box for any assertion that fails. |
| RwFontChangeSizing=False | | |
| RWLayoutPropertiesSheet=822,25,270,349 | GP | Used to save the coordinates of the Properties window within Report Writer. |
| RWLayoutPropertiesSheetTab=2 | GP | Used to save which tab is selected in the Properties window within Report Writer |
| RWLayoutPropertiesSheetVisible=TRUE | GP | Used to indicate if the Properties window within Report Writer is visible. |
| SAMPLEDATEMMDDYYYY=00000000 | GP | To prevent the dialog box from being displayed and to use the current system date |
| SAMPLEDATEMMDDYYYY=MMDDYYYY | GP | To prevent the dialog box from being displayed and to use a user-specified date |
| SAMPLEDATEMSG=FALSE | GP | To prevent the dialog box from being displayed while leaving the date as April 12, 2017. |
| ScriptDebugger=TRUE | GP | Turn Script Debugger Features on in Runtime Mode. |
| ScriptDebuggerProduct= | GP | Specify Product ID of product to be debugged to allow Open Script. |
semicolon (;) in front of the ST_MachineID= setting | GP | Turns off Named Printers for that workstation |
| ShowAdvancedMacroMenu=TRUE | GP & Dex | Display additional menu under Tools >Macro. |
| ShowAllMenuItems=TRUE | GP | Shows all menu items even if the user does not have access to them. This doesn’t change the user’s access to the windows, it just will display the menu items even if they have been disabled. |
| ShowReportName=FALSE | GP & Dex | Keeps the Screen Output window from displaying the current report's display name. |
| ShowResIDs=TRUE | Dex | This line will allow Dexterity to show the Resource ID of the current script in the script editor as well as showing the column ID & Res Type in the Dexterity Resource Explorer |
SkipVersionChecks=TRUE | GP & Dex | To disable version compatibility checking. DANGER |
SmartlistMatchCasePrefs=TRUE | Pre GP10 | This change to the Dex.ini file enables the following two options for the SmartList security settings: – Mark the ‘Match Case’ checkbox by default when performing searches. – Disable the ‘Match Case’ checkbox on the SmartList Search window. |
| SQLDataSource = data_source_name | Dex | This setting allows you to define a default value to appear in the Data Source field of Dexterity's predefined SQL Login window. The SQLDataSource setting won’t affect a login window you create unless you use the Defaults_Read() function and the set statement to make this setting’s value appear as the default value for the data source field. |
| SQLDataSource = data_source_name | Dex | This setting causes the specified data source name to appear in the Data Source field in Dexterity's SQL Login window. A user may choose another value from the drop-down list, should he or she want to connect to a different data source. The SQLDataSource setting won’t affect a login window you create unless you use the Defaults_Read() function and the set statement to make this setting’s value appear as the default value for the data source field. |
| SQLDropTableOnDelete=TRUE | GP & Dex | Will cause the drop functionality, which removes the data AND the table structure from the database, when the delete table statement is used with a SQL table. Unless the Table_SetCreateMode() is set to true, the dropped tables won't be created automatically then next time a user tries to access them. DANGER |
| SQLDynamicScrollJump = number | GP | number - The maximum number of rows a cursor will move when a user moves the scroll box, the default is 100. |
| SQLLastDataSource= data_source_name | GP | The name of the most recently accessed data source. That value will then appear as the default in the predefined Login window the next time that window is used on the current computer. |
| SQLLastUser = user_ID | GP | The user ID of the most recent user to connect to a data source using the current computer. |
| SQLLoginTimeout = number_of_seconds | GP | Limits the length of time (in seconds) your application will wait for a data source login attempt to be completed. A login doesn’t have to be successful to be completed; rather, an attempt to log in must be made and a status code defining the result of that attempt must be returned. The default is 15 seconds if this entry is not included in the dex.ini. To cause your application to wait indefinitely for a status code to be returned, set this value to 0 (zero). |
| SQLLogODBCMessages=TRUE | GP & Dex | Log ODBC messages returned from SQL Server to DEX.SQL file. |
| SQLLogPath=path | GP & Dex | This setting allows you to specify the location of the DEXSQL.LOG file created when either or both the SQLLogODBCMessages or the SQLLogSQLStmt defaults file settings are active. |
| SQLLogSQLStmt=TRUE | GP & Dex | Log SQL statements being sent to SQL Server to DEX.SQL file |
| SQLNumLoginTries = number | GP | The maximum number of login attempts allowed before GP exits. The default is three. Use negative one (-1) for an unlimited number of tries. |
| SQLPassword = password | GP | This setting allows you to define the default password that will appear in the password field when logging into a data source using Dexterity’s predefined SQL Login window. This setting won't affect a login window you create for use with your application unless you use the Defaults_Read() function and the set statement to make this setting's value appear as the default value. |
| SQLUser = user_ID | Dex | This setting allows you to define a specific user ID as the default value to use in the User ID field of Dexterity’s predefined SQL Login window. The SQLUser setting won't affect a login window you create for use with your application unless you use the Defaults_Read() function and the set statement to make this setting's value appear as the default value for your own user ID field. |
| ST_Debug=LOG | GP | Creates a log file in the local code folder named ST_DEBUG.LOG that can be used to troubleshoot Named Printers. In v 10 this log file is created in the \Data subfolder inside the local code folder. |
| ST_SetDefault = FALSE | GP | Turns off the setting of default printers in named printers |
| StdInternationalInfo=TRUE | Dex | The date format will not be pulled from International setting and will instead use a default format of mm/dd/yy. |
| SuppressChangeDateDialog=True | GP | To keep an integration from failing if the integration is running when the computer’s clock hits midnight, |
| SuppressSound=TRUE | GP & Dex | Stop Dexterity and Dynamics generating any sounds. |
| Synchronize=FALSE | GP | Indicates that the account number framework stored in the Dynamics.dic dictionary doesn't match the data for the current company, and that GP Utilities must be used to synchronize the framework to the data. TRUE is the default value. |
| Synchronize=FALSE | GP | Indicates whether Dynamics Utilities has synchronized the Dynamics.dic to the account framework that is defined in Dynamics Utilities. FALSE signifies that the Dynamics.dic has been synchronized. If a user needs to resynchronize the dictionary, this line should be modified to equal TRUE and then launch Dynamics Utilities. |
| Tolerance=0 | GP | The Tolerance command will ignore the font defaults and force the system to use the font utilized in |
| Tolerance=-1 | GP | The Tolerance command will ignore the font defaults and force the system to use a true type font. |
| Tolerance=100 | GP | The Tolerance command will ignore the font defaults and force the system to use the default font set in |
| TXFileDate=31 Dec 2006 | GP | Indicates the date of the last payroll tax table update. |
| UpdateLogin=https://mbsupdates.microsoft.com/taxupdate/login.aspx | GP | The entry that should be in the .ini file so the payroll tax updates will connect correctly. |
| UseUniqueHelp=FALSE | Dex | This setting allows you to override the default value for the UseUniqueHelp property for fields when implementing context-sensitive online help. FALSE indicates that the UseUniqueHelp property will default to False for new fields. |
| WDC_DEBUG=LOG | Pre GP10 | This will create a WDC_SDBG.log file in your local code folder to use debugging Advanced Security Issues |
| WDC_SecurityDisableWarning=TRUE | Pre GP10 | This keeps GP from asking if you want to open advanced security instead of regular security when you select regular security from System setup |
| WindowGridHeight = height in pixels | Dex | This setting allows you to define the height in pixels of a grid block in the Layout window. |
| WindowGridWidth = width in pixels | Dex | This setting allows you to define the width in pixels of a grid block in the Layout window. |
| WindowHeight=n | Pre GP10 | The height of the Main Window in Dynamics if WindowMax=FALSE |
| WindowMax=TRUE | Pre GP10 | This parameter is used to verify the size of the Main Window in Dynamics. If the setting is set to TRUE, it is full screen. If the setting is FALSE, adjustments have been made and additional Window parameters will be listed below the WindowMax setting. |
| WindowPosX=n | Pre GP10 | The X position of the Main Window in Dynamics if WindowMax=FALSE |
| WindowPosY=n | Pre GP10 | The Y position of the Main Window in Dynamics if WindowMax=FALSE |
| WindowWidth=n | Pre GP10 | The width of the Main Window in Dynamics if WindowMax=FALSE |
| Workstation=location_translation_ID | GP | Location translation ID that is found in the Location Translation table. This line would be modified if a user has created an additional location translation in the Location Translation Setup window. This line will default as equal to WINDOWS. |
| Workstation2 = dictionary_location_ID | GP | The dictionary_location_ID indicates a set of dictionaries in the Dynamics.set file that you want a given workstation to use. Each set determines the location of the main dictionary and its forms and reports dictionaries. |
| WysiwygLayout=TRUE | GP | Saves the setting in Modifier as to whether the field names are displayed. TRUE means the field names are not displayed. FALSE means the field names are displayed. |
| ZoomFontColor=Green | GP | Saves settings in the Display area of the User Preference settings. |
| ZoomFontUnderline=True | GP | Saves settings in the Display area of the User Preference settings. |
Subscribe to:
Posts (Atom)
