Search results matching tag 'eConnectOut'

Re: Econnect GL Transaction

ravishankarp — Wed, 12 Aug 2009 17:02:29 GMT

Hi I am also getting the following error while integrating GL transaction having around 1600 GL Line Entris including Analytical Accounting information. I have changed the connection timeout in component services but no use.

I am trying to integrate GL Entries using eConnect. Some integrations are working fine but some integrations are giving the following errors

1) A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host)

2) The root transaction wanted to commit, but transaction aborted (Exception from HRESULT: 0x8004E002)

3) the timeout period elapsed prior to completion of the operation

Your urgent response (or) advise is required , as it is stopping the user activities.

Most of the times these errors are occuring if the xml file is large.

Create a new (Fixed asset General)... How to set the (CurrencyID and VendorID in the econnect schema taCreateAssetID )

:::Ashley::: — Fri, 03 Apr 2009 17:28:55 GMT

Hi,
I would like to create an Asset general information in Great Plains using econnect.
I use the <taCreateAssetID> schema but i don't know how to set the CurrencyID and the VendorID (Asset purchase windows).

There are any champ in the taCreateAssetID schema for set the theses values.

Thanks before hand.

:::Ashley:::

eConnectOut for vendors with c#

arvindpnr — Mon, 04 Aug 2008 11:13:22 GMT

Hi,

We have an example of eConnectout in Vb.Net which is bit confusing has anyone worked upon eConnectout using csharp.

Thanks in advance.

Arvind

Importing Data from MYSQL to MS GP

Saif — Mon, 23 Jun 2008 07:40:16 GMT

Hi, all

I am very new to this concept and the ERP of microsoft. I really do not know where my query fits into, if iam at a wrong place hope you guide me to right place.

coming on to my query, i have an application which uses MYSQL as its Database. It generates a data which is stored in a table. The requirement now is, i want to migrate the Data in this particular table to the Data base of MS GP, may be i need to create a new table in the GP itself to accommodate this new data. Will i be able to achieve this, if so then how? Do i need to use eConnect to achieve my purpose or are there any other tools which will help me in achieving this task, like some adapters provided by MS GP. I am keen on seeking a suggestion.

Regards

EConnect generate Item UOFM error when sending Sales Order

phamdachoang — Mon, 02 Jun 2008 09:25:33 GMT

Hi every body

I am a newbiew of GP 10. I used Econnect 10 to send my Purchase Order to GP as Sales Order

I tried to send Purch as GO Sales Order. Sometime, it transferred data successful but sometimes this generates following error:

Sql procedure error codes returned: Error Number = 1599 Stored Procedure taSopLineIvcInsert Error Description = The UOFM for the item is not specified in the Item Price List as a Default Selling UofM Node Identifier Parameters: taSopLineIvcInsert SOPNUMBE = ORDST2270 SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert UOFM = Note: This parameter was not passed in, no value for the parameter will be returned. Error Number = 5313 Stored Procedure taSopLineIvcInsert Error Description = Unit of Measure does not exist for the Unit of Measure Schedule being used Node Identifier Parameters: taSopLineIvcInsert SOPNUMBE = ORDST2270 SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert NONINVEN = Note: This parameter was not passed in, no value for the parameter will be returned. UOFM = Note: This parameter was not passed in, no value for the parameter will be returned. Error Number = 771 Stored Procedure taSopLineIvcInsert Error Description = Price Level is blank, it must either be passed in or a default must exist for the transaction Node Identifier Parameters: taSopLineIvcInsert SOPNUMBE = ORDST2270 SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert PRCLEVEL = Note: This parameter was not passed in, no value for the parameter will be returned.

Athough I declaired

lineItem.UOFM = GetXmlTextFromGPItem("1-A3483A") // -->This funtion return "Each".

lineItem.NONINVEN =0

string GetXmlTextFromGPItem(string gpItemID)

{

XmlNode itemnode= _itemDocXml.SelectSingleNode(string.Format("descendant::eConnect/Item[ITEMNMBR= '{0}']", gpItemID));

XmlNode valueNode =null;
    if (itemnode!=null)
        valueNode =itemnode.SelectSingleNode("SELNGUOM");

    if (valueNode!=null)

return valueNode.InnerText;

return string.Empty;

}

Please help me solve this problem

Thanks and best regards

Re: How to import GP 10 Sales Invoice?

phamdachoang — Wed, 21 May 2008 07:14:44 GMT

Hi Mr Steve Gray

First of all , I want to say Thanks for your support.

I have another question. When exporting my purchase order to GP ( I used Econnect 10 with 2 classes taSopHdrIvcInsert. and taSopLineIvcInsert_ItemsTaSopLineIvcInsert). After sending data to GP, I see my orders come to Sales Module\ Enquiry\ Sales Document.

Why orders don't come to Sales Modules\ Sales Order Transaction. I come to Sales Modules\All Sales Transaction but I do not see my orders?

How can I change orders from Enquiry to Sales Transaction?

Thanks and best regards

Hoang

How to import GP 10 Sales Invoice?

phamdachoang — Tue, 20 May 2008 09:03:17 GMT

Hi everybody, please help me

I am writting an intergration application with Great Plains version 10.0

Here is my flow:

1. I collected my purchase orders and used Econnect 10 to send to GP sales documents. After sending, I can see my order at Sales\Enqury\Sales Documents.

2.In GP 10 enviroment, I tried to post my sales orders to Sales Invoices. I do not use Invoicing Transaction because of this reason below

http://www.articlecity.com/articles/computers_and_internet/article_759.shtml

3. After posting Sales Invoices, I used Econnect Requester 10 again to import Sales Invoices to my system.

The problem is: As I knew, sales order, sales Invoice, Fullfillment order, back order are stored in same table (SOP10100). After creating Invoice, SONUMBE column is used to store new InvoiceNumber? How can I get original number Sales Order ID?

Thanks and best regards

Hoang Pham

Login failed error

sensoft2000 — Wed, 05 Mar 2008 14:55:27 GMT

Hi,
In our office environment, we installed the GP database server in another server (Ex: ServerName: PCNUM1\SQL2005). And they installed Econnect in my Desktop. I am able to connect to that SQL server using SQL server credentials (In econnect 10--> Requester setup & Microsoft Sql server management studio express). But I am not able to connect using "Windows Authentication".

In this scenario, How can i use the EConnect to get/insert value into GP server.? Because, I am getting "Login failed for user ''. The user is not associated with a trusted SQL Server connection." error, while running the source code.

for more info, please see my code below:

Dim strConnect As String = "data source=PCNUM1\SQL2005; initial catalog=TWO; integrated security=SSPI; persist security info=False; packet size=4096"

Dim eConnResult As Boolean

'Instantiate an eConnectMethods object

Dim eConnObject As New eConnectMethods

Dim xDoc As New XmlDocument

Dim xmlStr As String

xmlStr = "<eConnect>"

xmlStr = xmlStr & "<RMCustomerMasterType>"

xmlStr = xmlStr & "<taUpdateCreateCustomerRcd>"

xmlStr = xmlStr & "<CUSTNMBR>MYCUSTNUMBER</CUSTNMBR>"

xmlStr = xmlStr & "<CUSTNAME>MYCUSTNAME</CUSTNAME>"

xmlStr = xmlStr & "</taUpdateCreateCustomerRcd>"

xmlStr = xmlStr & "</RMCustomerMasterType>"

xmlStr = xmlStr & "</eConnect>"

xDoc.LoadXml(xmlStr)

Try

'If the update returned TRUE, it was successfully completed

eConnResult = eConnObject.eConnect_EntryPoint(strConnect, EnumTypes.ConnectionStringType.SqlClient, xDoc.OuterXml, EnumTypes.SchemaValidationType.None)

Catch ex As eConnectException

Throw New Exception(ex.Message)

Catch ex As System.Data.SqlClient.SqlException

Dim myError As System.Data.SqlClient.SqlError

Dim strMsg As String = ""

For Each myError In ex.Errors

strMsg += myError.Message + vbCrLf

Throw New Exception(strMsg)

Catch ex As Exception

Throw New Exception(ex.Message)

End Try

What are the web methods available for write web services in Dynamic Greate Plains? Please give Sample for update backend table data through web services

umanath — Thu, 20 Dec 2007 03:58:38 GMT

I am umanath, I use Microsoft Gynamic GP10.0, how to write web services to update data in side GP10.0 ?

And i choose eConnect to retrive & Update data into GP10.0 back end data. So this way is correct or not ?

Finaly which web methods are avilable in GP10.0 for i will write new web services ?

What are the web metodes available for write web services in Dynamic Greate Plains? Please give Sample for update backend table data through web services

Re: Getting company info

Joe Cogan — Tue, 17 Jul 2007 12:54:12 GMT

Antoine,

Concerning your "Doc Types" reference: The eConnect_Out_Setup table contains all the available doc types you can use in the eConnectOut transaction. I wrote a .Net wrapper (in C#) to grab all available Doc Types and return them as a string array:

private static string QUERY_DOCTYPES1 = @"SELECT DISTINCT DOCTYPE FROM dbo.eConnect_Out_Setup ORDER BY DOCTYPE ASC";

/// <summary>
/// RequesterDocTypes: returns an array of names of all available
/// DocTypes that can be retrieved through the eConnect requester
/// interface.
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static string[] RequesterDocTypes(string connection)
   {
   // query the database for the available requester types
   SqlConnection scon;
   SqlCommand scmd;
   SqlDataReader sdr;
   List<string> s;
   scon = new SqlConnection(connection);
   scon.Open();
   scmd = new SqlCommand(QUERY_DOCTYPES1, scon);
   sdr = scmd.ExecuteReader();
   s = new List<string>()
   while (sdr.Read())
   {
   s.Add(sdr.GetString(0));
   }
   return (s.ToArray());
}

Hope this helps. Take care!

Joe Cogan
Real Time Intelligence, Inc.
www.rtintel.com