GP Web Services and Invalid Character Errors

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

I am going to go over the steps to find and resolve invalid data characters in Dynamics GP that cause GP Web Services exceptions.   A common process of “copying and pasting” a block of text from an external program into the Note window for a Dynamics GP record or an import routine directly to the SQL tables can cause Dynamics GP Web Service to throw an error.   When using a .Net application that does a GetSalesOrderByKey error, you may see something like this:

“The application encountered an unhandled system exception.  Contact your system administrator for details.”

Using a GP Web Service Extension in the Connector for Microsoft Dynamics GP

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

The Connector for Microsoft Dynamics provides a powerful integration platform that can be customized and extended with the CRM Connector SDK and Web Services for Microsoft Dynamics GP SDK tool sets.  The CRM Connector for Microsoft Dynamics GP page in PartnerSource has various downloads to get you started with the CRM Connector including the SDK download.   You can find the GP Web Services SDK download here.  Additionally, the Dynamics GP Web Services SDK page on MSDN contains the same reference information found in the download page and is available to those without accessing PartnerSource or CustomerSource and can be helpful for quick access.

Choosing between eConnect for Microsoft Dynamics GP and Web Services for Microsoft Dynamics GP

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

Should I write this integration using eConnect or Web Services for Microsoft Dynamics GP?   This is often a question we receive at conferences like Convergence or in support cases from both Customers and Partners.  Like most questions in our field, there really is no concrete answer to this one.  The answer is usually the dreaded “Well, it depends on…”.   What I hope to do here with this post is point out some of the differences of the two integration platforms, give you my opinion on what I like about them, and then you can decide how you would leverage them in your own projects.

Retrieve more than 1000 Records using Web Services for Microsoft Dynamics GP 2010

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

A question we have received in the past in Developer Support is how to retrieve more than 1000 records using Web Services.   The maximum number of records a GetList method will return is 1000 records.  This is by design as this value is coded into the call to eConnect and it cannot be changed with a configuration file.

Cannot activate workflow in Dynamics GP

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

Recently one of the support engineers had a case they asked for my help on.

Dynamics Workflow was installed and a new PO Workflow was created and activated in Sharepoint. From the Sharepoint side, everything seemed to be working correctly.

Web Services Configuration Settings for Integrating Large Transactions

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!

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

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.

How to retrieve Quantity On Hand amount using Web Services for Dynamics GP 10.0

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

This post is due to requests I have come across in the past and very recently in a support incident.  The question raised was how to retrieve quantity amounts like Quantity On Hand for inventory items?  This Visual Studio 2005 (C#) sample shows how to retrieve the Quantity On Hand value for an Inventory Item.  The SalesItem class provides a Quantities property which is a collection of SalesItemWarehouse objects.  The SalesItemWarehouse object contains the different quantity amounts for each Item and Site combination.  These values are stored in the IV00102 table.

Choosing a Development Tool

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.