David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have had two support cases with this issue recently.  So I thought I would post an explanation of the problem along with a script to fix it. The good news is that the underlying cause of the issue has been fixed in Microsoft Dynamics GP 2010 (v11.00).

Read more →

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

I recently had a case that I thought I’d share with you. A well known ISV opened an incident with Developer Support to help solve an issue at their customer site.

This ISV has an application that encrypts certain sensitive data in the custom application in the ISV’s custom table in their own Dexterity based window.

The complaint given: After opening the custom window and making the application perform the decrypted data, when the window closes and the Dynamics navigation shell has focus – Dynamics GP crashes with the “Dynamics Runtime has encountered an error and needs to close..” dialog.

Read more →

Dawn Langlie - Click for blog homepageThis is a reposting of an article Dawn Langlie originally wrote on my Developing for Dynamics GP blog.

I recently had a support case, running a Fixed Asset integration with Integration Manager, where we received the following error:

DOC 1 ERROR: System.FormatException: String was not recognized as a valid DateTime.

at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType)

Read more →

trick Roth - Click for blog homepageThis is a reposting of an article trick Roth originally wrote on my Developing for Dynamics GP blog.

A few months ago, a partner was attempting to create an Application.Dynamics.ModifiedForms.dll using the Dictionary Application Generator (dag.exe) against his 9.0 SP4 Dynamics forms dictionary.

This failed for him.  Trying to determine if it was a “forms dictionary issue” or not, he renamed his Application.Dynamics.dll as a test and attempted to generate a new one using Dag.exe.  This also failed in the same manner but at a different spot.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was asked recently about the Note Index field and how it is used and in particular about the Note Index field in SY01500 table in the DYNAMICS system database.  This post will explain how the field is used as well as explain how it is possible to create the conditions that will generate cross linked notes.  Understanding how the conditions can be created will allow you to avoid that situation from occurring.

Read more →