Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Last week, I posted the article below explaining how you can use the osql.exe command to run a script against all Microsoft Dynamics GP company databases. The method described in this post is best if you have a *.sql script file to execute against each company database:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This post explains how to use Microsoft Office Word’s Mail Merge functionality to Import Data into Microsoft Dynamics GP. This method can be useful when working with master records or transactions not supported by any of the existing tools such as Integration Manager, eConnect or Web Services.
[Edit] See note about John Arnold’s Replicator Tool at the bottom of this article.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
While administering a Microsoft Dynamics GP system, there are times when a fix or change needs to be applied to each company in the system at the SQL Server level. On a system with a large number of companies this can be a very time consuming task.
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.
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.
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.
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.
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.
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.
For those of you who have been involved with the Great Plains product for a while, you will remember the “Welcome to Dynamics” wave that played when the application was launched. Well, if you want that functionality again, you can use VBA to add it back.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have not read part 1 of this posting it can be found using the link below:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When logging into the Fabrikam sample company with Microsoft Dynamics GP, the current user date will be set to April 12, 2017 and you will be presented with a dialog with the following message:
Read more »
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A long time discussion in the Microsoft Dynamics GP world is how to handle the distribution of customizations and updates. There are a number of approaches available and this article discusses the benefits and issues of the different configurations.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I saw a newsgroup posting today asking this common question. You might ask “Master records like Customers and Vendors let me discard changes, so why not transactions?”
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Some of you might know that I was the original developer of Named Printers. I was working with the West Australian partner Sequel Technology at the time. It was created back in version 3.0 as a customisation for a distribution client who wanted to be able to print SOP picking tickets to the warehouse while printing the SOP invoices to the accounting department’s printer.