Archive for the ‘System’ Category
Screen Output Magnification Defaults
There was a support request on the forum today, where the user was questioning the setup from where the default zoom for screen outputs in GP is picked up from. There is a setting the Dex.ini file which determines the Screen Output Magnification Default. It is MagnifyScreenOutput. Depending on the value defined for this parameter, [...]
August 13, 2011 · 
veeyeskay · 
2 Comments
Tags: MagnifyScreenOutput, screen output magnification default · Posted in: Dex.ini, Dynamics, Great Plains, System Total Views: 87
Drill downs in the Security Setup windows
This article explains a very simple feature which may times goes unnoticed in Microsoft Dynamics GP 10 and 2010. We have many windows where we define the security related information. They are listed below. Security Task Security Roles User Security Alternate Modified Forms & Reports In the windows listed above, you can drill down into [...]
August 10, 2011 · veeyeskay · 2 Comments
Tags: alternate forms, alternate reports, Drill Down Capabilities, Modified Forms, Modified Reports, security window enhancements, security-roles, security-tasks, user security · Posted in: Dynamics, Great Plains, Security, System Total Views: 107
Security Window Enhancements in Dynamics GP 2010
One of the cool enhancements (which mostly goes unnoticed) in Dynamics GP 2010 is the new checkbox which is applicable in the Security windows explained below, which allows the users to see only the options selected for the particular record (i.e.) in case of the Security Roles window, the checkbox allows us to filter and [...]
August 9, 2011 · veeyeskay · 2 Comments
Tags: display selected items, dynamics gp 2010, security window enhancements, security-roles, security-tasks, user security · Posted in: Dynamics, Great Plains, Security, System Total Views: 126
Summary of Transaction Statuses in GP
All transaction in Dynamics GP, goes through 3 statuses before its purged from the system. They are Work Status – Transactions which have not been posted Open Status – Transactions which have been posted Historical Status – Transactions which have moved to history tables Each transaction moves through each of these status in various scenarios, [...]
May 8, 2011 · veeyeskay · No Comments
Tags: Historical Status, Open Status, Transaction Status, Work Status · Posted in: Dynamics, Great Plains, System Total Views: 193
Rebuilding Corrupt Resource Descriptions in Dynamics GP
Hi all Today, I was working with one of my colleague on an issue he faced in using the Resource Description functionality to view table and field information for a few tables. When he was browsing through the table details, he noticed that the actual SQL table definition and the table definition in the Resource [...]
May 6, 2011 · veeyeskay · No Comments
Tags: Corruption of Indexes, Index Rebuild, OLFD001.dat, OLFD001.idx, Resource Descriptions · Posted in: Dynamics, Great Plains, System Total Views: 204
Dynamics GP Technical Database Guide –DYNAMICS Database
Hi all In this article, I have posted the link to my Christmas present to the community folks. This is a detailed database guide for Microsoft Dynamics GP. I have posted the link to the guide for the system database (DYNAMICS). The company database guide will follow. This guide provides detailed specifications of the [...]
December 27, 2010 · veeyeskay · 4 Comments
Tags: Database Guide, DYNAMICS database · Posted in: Dynamics, Great Plains, SQL Server 2005, System Total Views: 683
Dynamics GP 10 Login Issue After Upgrade from Great Plains v8
Hi all I was in the process of upgrading one of our clients from Microsoft Business Solutions Great Plains v8 to Microsoft Dynamics GP SP4. The upgrade process went fine, but after the upgrade was completed, I landed up at a strange issue where none of the users were able to login and they were [...]
June 14, 2010 · veeyeskay · One Comment
Tags: David Musgrave, Dex.ini, Dynamics GP Upgrade, Encryption, Encryption Algorithm, SQLLoginCompatibilityMode · Posted in: Dynamics, Great Plains, System Total Views: 3,240
SQL Script to delete stranded activity for a specific user
Hi all In this article I am providing a script to delete the activity table records for a specific stranded user in Dynamics GP. This will enable us not to have all the users log out of GP in order to execute these scripts. This is typically handy when we have many users signed into [...]
May 16, 2010 · veeyeskay · 5 Comments
Tags: ACTIVITY, DEX_LOCK, DEX_SESSION, DYNAMICS database, Stranded User, SY00800, SY00801, User Activity · Posted in: Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, System Total Views: 1,440
Recovering the System Menu Password in Dynamics GP
Hi all How many times have consultants faced the situation where the system menu password in Dynamics GP is forgotten? This typically happens when we return to a client for an upgrade after about a year and it happens to be the case where the client side admin has forgotten the password as well… Most [...]
May 16, 2010 · veeyeskay · 4 Comments
Tags: Report Destination, Report Writer, System Password, System Password Recovery · Posted in: Dynamics, Great Plains, System Total Views: 2,463
Smartlist Window Splitter Control – Product Suggestion
Hi all… I am sure many of you have faced this problem in Smartlists… The splitter control in the smartlist window is currently not resizable. Because of this, when the smartlist window is maximized, the smartlist window is exactly split into half, with only the right half available to see the data, and there is [...]
April 26, 2010 · veeyeskay · 3 Comments
Tags: Smartlist · Posted in: Dynamics, Great Plains, System Total Views: 707