Integration Manager Customer Address Update does not generate an error and does not update

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

I worked on a Integration Manager 2010 case recently for a Customer update integration.  We ran across an issue when the customer you are updating has the Send Email Statement box marked in the Customer Maintenance Option window.  I also had the previous Customer’s address getting updated with the information from the Customer that had the Send Email Statements marked.

Continue reading

Fixed Asset Integration error: “String was not recognized as a valid DateTime”

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)

Continue reading

Copying Record Notes and OLE Attachments between Companies

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

Following on from last week’s post on OLE Attachments and Record Notes, I can now get to the reason for the interest in notes and OLE attachments.

The partner was trying to copy master records for Vendors from one company to a new company.  They wanted to use SmartList to export the Vendor data out of the source company and then use Integration Manager to bring the data into the target company.  The problem was how to handle the record notes that may be attached and how to handle the OLE attachments if they existed.

Continue reading

Passing data from a Business Portal Result Viewer Web Part to Dynamics GP Web Services

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

This post will provide some steps on using the MBF Result Viewer API to pass data to the Dynamics GP Web Services.    The specific example shows how you can remove a line item from a Sales Order using the UpdateSalesOrder method.   The sales order number, line sequence number, and item number can be pulled off the Rich List Result Viewer web part and passed to the web services.

Continue reading

How to use Word Mail Merge and Macros to Import Data

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

Continue reading