eConnect – Page 2 – Winthrop Development Consultants Blog

Serializing CDATA tags in eConnect XML Documents

Mar 18, 2010 Tagged with C#, Chris Roehrich, Developer Toolkit, eConnect, NDM, XML 1 Comment

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

I had a recent support incident where the customer was trying to update a field to a blank value using the eConnect serialization assembly and the value was not being removed. Specifically, they were attempting to remove the existing value in the ADDRESS2 column of the RM00101 table by setting the string value to a blank value. The reason why this was happening was really by design with the eConnect stored procedures. If you do not pass a value, eConnect will use the setup in Dynamics GP to default the value if one exists. This works great because then as a developer you do not have to worry about passing everything in with the XML document. That would be painful to have to pass everything in the XML document for being fearful of having data being removed.

Developing For Dynamics GP

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

Jan 28, 2010 Tagged with Dawn Langlie, eConnect, Exception, Fixed Assets, Integration, Integration Manager, NDM No Comments

This 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)

Developing For Dynamics GP

Filtering eConnect Requester data

Dec 3, 2009 Tagged with eConnect, Emily Halvorson, NDM, Row Level Filtering, SQL, Triggers 6 Comments

This is a reposting of an article Emily Halvorson originally wrote on my Developing for Dynamics GP blog.

I wanted to tell you about a recent case I had where the Partner was trying to restrict the Microsoft Dynamics GP data they had selected with the eConnect Requester Setup Tool.

They were first importing some of their Sales Orders from an external system into GP with eConnect. Then when they fulfilled and shipped the Order within GP, they used eConnect Outgoing Queue to make the updates available to the external system. Their use of GP also includes manually entered Sales Orders and they did not want the updates to the manually entered Orders to be queued.

Developing For Dynamics GP

Where are Dynamics GP’s Business Rules Defined and Enforced?

Aug 2, 2009 Tagged with Application, Dexterity, eConnect, History, Integration Manager, SQL, VBA 4 Comments

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.

Developing For Dynamics GP

Web Services Configuration Settings for Integrating Large Transactions

Jun 26, 2009 Tagged with Chris Roehrich, eConnect, NDM, Web Services 2 Comments

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

It is definitely possible to use Web Services for Microsoft Dynamics GP to create large transactions. By large transactions I am referring to examples of where a sales invoice would have several thousands of lines on it. That’s right, some companies are integrating transactions this large using our Web Services for Dynamics GP!

Developing For Dynamics GP

Development White Papers for Download

May 19, 2009 Tagged with C#, Dexterity, eConnect, VB, Visual Studio Tools 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I recently came across some development tool based White Papers which are available for download from Microsoft Downloads. I thought I would highlight them as they are worth a read:

Developing For Dynamics GP

eConnect for Microsoft Dynamics GP does not roll back transactions when an error occurs during the import

Apr 21, 2009 Tagged with David Clauson, eConnect, NDM 4 Comments

This is a reposting of an article David Clauson originally wrote on my Developing for Dynamics GP blog.

SUMMARY

Data being integrated with eConnect is leaving records in Microsoft Dynamics GP tables when there is an error being returned. eConnect should be rolling back the data out of Microsoft Dynamics GP tables.

Developing For Dynamics GP

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

Jan 18, 2009 Tagged with Business Portal, C#, Chris Roehrich, Developer Toolkit, eConnect, Integration, NDM, Web Services 2 Comments

This 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.

Developing For Dynamics GP

Choosing a Development Tool

Aug 10, 2008 Tagged with Developer Toolkit, Development Tools, Dexterity, eConnect, Hybrid, Modifier, Visual Studio Tools, Web Services 7 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of the great things about Microsoft Dynamics GP is the fact that there so many options available to integrate with or customise the application.

Tag: eConnect