Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When I started this blog, one of my goals was to help developers push the boundaries of what they believe is possible. This was the foundation of the materials presented at conferences by myself and Mark Rockwell. For more information on the conference sessions and materials have a look at the Cross Dictionary Dexterity Development post.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today I saw another posting on the Microsoft Dynamics GP Community Forum about an error when going into Dexterity test mode after upgrading an application from a previous version to version 10.0.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Since the release of Microsoft Dynamics GP v10.0 I have seen this question asked many times over on the various newsgroups I monitor (see the Newsgroups Links on the left hand panel of the blog).
The quick answer is…. it has moved into the Data subfolder.
David
— End of Post —
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Time to get into some Dexterity code. I saw a posting today on the Microsoft Dynamics GP community forum. It was asking about the disappearance of the Void Button from the SOP_Entry form and how to work with the new Action Button.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have ever spent time analysing a DEXSQL.LOG file you might have seen a reference to a table column called desSPRkmhBBCreh. This post explains what this column is used for and why it has the name it does.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
After the release of Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0, my good friend Mariano Gomez asked me if it was possible to use the tool to add menus from Visual Basic for Applications (VBA).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been involved in the Great Plains world now since 1994. During that time I have become known for my work with development techniques and pushing the boundaries of what is possible.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials”zDP”. This article explains what the zDP stored procedures do and why they exist.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website. The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Developers using Visual Studio Tools for Microsoft Dynamics GP with forms that contain scrolling windows might have noticed that the LineFill events are missing from v9.0 and v10.0, this posting explains why they were missing and why they have been added back.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Why doesn’t the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>?
Why does my password sometimes fail to work from one workstation when it works from another?
Why does the password policy feature only allow one failed attempt before locking me out?
Why is the User ID case sensitive on Microsoft Dynamics GP v10.00?
What is the Password field in the SY_Users_MSTR (SY01400) table used for?
Can I use my Windows or Active Directory Login to access Microsoft Dynamics GP?
I hope to answer all these questions and more by explaining the password encryption that is used by Microsoft Dynamics GP for all users except ‘sa’.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I did not start this thread, but I thought I would give a bit of insight into the subject.
Vaidy Mohan on his blog posted about Test Company Message while logging on to Dynamics GP.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have seen a number of occasions where a consultant has been asked to add a paragraph of text to a graphic report and has found it almost impossible to get the text to display nicely in both screen and printer outputs.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Even though support for a splash screen was added to Dexterity v3.00, Great Plains Dynamics v5.50 was the first version to include a splash.bmp file and Microsoft Business Solutions – Great Plains v8.00 was the last version to include a splash.bmp file. This uncompressed bitmap was displayed as a splash screen when the application was launched. A number of partners had worked out that the splash.bmp file could be customised to add a customer or partner logo, but now the splash.bmp file is not longer used.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer calculated fields of return type string are limited to 80 characters. This means that if your amount in words is longer than 80 characters, only the first 80 characters will be returned and the rest will be truncated and lost.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: Menus for Visual Studio Tools is now Visual Studio Integration Toolkit from Winthrop Development Consultants (https://winthropdc.com/VSIT)
Some brilliant news for Microsoft Visual Studio developers who use Visual Studio Tools to integrate with Microsoft Dynamics GP 10.0.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
There are times when Microsoft Dynamics GP fails to display currency and quantity numbers greater than 999 after they have been saved.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example shows how you can set a lookup window to open with a default sort order. The reason that this is normally difficult is that the usual methods that people use to set defaults with VBA do not work on lookup windows.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez. We had both seen a newsgroup posting asking if it was possible to add access to the Item Master’s record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could do it and this morning sent me the first version of his code as a package.