GP Web Services and Invalid Character Errors


Chris Roehrich - Click for blog homepageThis 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.”

Continue reading

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


Chris Roehrich - Click for blog homepageThis 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.

Continue reading

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


Chris Roehrich - Click for blog homepageThis 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.

Continue reading

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


Chris Roehrich - Click for blog homepageThis 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.

Continue reading

Cannot activate workflow in Dynamics GP


Patrick Roth - Click for blog homepageThis 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.

Continue reading

Web Services Configuration Settings for Integrating Large Transactions


Chris Roehrich - Click for blog homepageThis 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!

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