Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was asked recently if it was possible to create a Shortcut from Microsoft Dynamics GP to launch an external application and pass parameters to the application.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
One of the major changes to the Microsoft Dynamics GP user interface occurred with the release of version 10.0. This change was from the MDI (Multiple Document Interface) to the SDI (Single Document Interface).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This is an oldie but a goodie. It came up again in the newsgroups recently.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have looked a DEXSQL.LOG file to see the communication between SQL Server and the Microsoft Dynamics GP application, you might have noticed messages with errors 5701 and 5703 being reported. See the example below:
/* /* Date: 08/10/2009 Time: 20:09:49 SQLSTATE:(01000) Native Err:(<strong>5701</strong>) stmt(0):*/ [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.*/ /* /* Date: 08/10/2009 Time: 20:09:49 SQLSTATE:(01000) Native Err:(<strong>5703</strong>) stmt(0):*/ [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/ /*
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Sometimes Microsoft Dynamics GP reports unusual errors with temporary tables. Here are some example error messages that you might see:
An open operation on table ‘IV_Reconcile_PO_TEMP’ has an incorrect record length.
An open operation on table ‘PM_Inquiry_Summary_TEMP’ failed because the path does not exist.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (https://winthropdc.com/GPPT)
I have been asked a few times recently about installing the Support Debugging Tool for Microsoft Dynamics GP on a live system. This post covers some of the Frequently Asked Questions about installing the tool.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In a recent forum post, the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When working with the Report Writer to print a report onto a preprinted form it is important to ensure that the report prints to the same position regardless of the printer or printer driver used. This article explains the option that allows a report to always print in the same physical position. This can also be handy for plain paper reports; for example: An invoice that had an address which needs to show through a “windowed” envelope.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In the previous article in this series, Microsoft Dynamics GP and Illegal Characters Part 1, we discussed how string delimiter or terminator characters can cause issues and need to be handled correctly. The article discussed the single quote (‘) and double quote (“) characters. Sometimes we have seen a single quote (‘) character cause problems at the SQL level when it is included in a data field and not handled correctly by the code.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Over the years that I have worked with Microsoft Dynamics GP, there are been a few occasions where we have had issues with so called “illegal” characters.