Print Page | Close Window

eConnect 10.0 POP Transaction

Printed From: Microsoft Dynamics Forums
Category: Microsoft Dynamics GP (Great Plains)
Forum Name: GP - Installation and Administration
Forum Discription: Installation, Upgrade, Service Pack, Security, Database, Administration, SQL Server, Login Issues, System Errors, Performance, EDI, Business Portal, and related topics
URL: http://www.MicrosoftDynamicsForums.com/forums/forum_posts.asp?TID=2716
Printed Date: April 03 2020 at 5:48pm


Topic: eConnect 10.0 POP Transaction
Posted By: balajid
Subject: eConnect 10.0 POP Transaction
Date Posted: June 27 2008 at 12:47am

Hi, 
 
I have just started to use eConnect 10.0 and had below error whn doing POP  Transaction into GP , I cannot  figure it out the problem . If anyone has seen  this before, I'd greatly appreciate your help. Thank you.

Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:Error Number = 370
 Stored Procedure taPoHdr  Error Description = Subtotal (SUBTOTAL) does not match the line item totalsNode Identifier Parameters: taPoHdr 
 BER = PO2076VENDORID = Advanced0001Related Error Code Parameters for Node :
 taPoHdrSUBTOTAL = 2<taPoHdr><PONUMBER>PO2076</PONUMBER><VENDORID>Advanced0001</VENDORID><VENDNAME>Advanced Office Systems</VENDNAME><DOCDATE>2007-04-14</DOCDATE><SUBTOTAL>2</SUBTOTAL></taPoHdr> ---> Microsoft.Dynamics.GP.eConnect.eConnectException: Error Number = 370  Stored Procedure taPoHdr  Error Description = Subtotal (SUBTOTAL) does not match the line item totals   --- End of inner exception stack trace ---Server stack trace:    at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML, SchemaValidationType ValidationType, String eConnectSchema)   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)Exception rethrown at [0]:   
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML,
 SchemaValidationType ValidationType, String eConnectSchema)   at _Default.btnCreate_Click(Object sender, EventArgs e)

POPTransactionType[] POPTransArray = new POPTransactionType[2];

POPTransactionType POPTransHdr = new POPTransactionType();
POPTransactionType POPTransLine = new POPTransactionType(); taPoLine_ItemsTaPoLine[] POPLine = new taPoLine_ItemsTaPoLine[2]; taPoLine_ItemsTaPoLine POPLine1 = new taPoLine_ItemsTaPoLine();
taPoHdr POPHdr = new taPoHdr();
POPHdr.PONUMBER =
"PO2076";
POPHdr.VENDORID =
"Advanced0001";
POPHdr.VENDNAME =
"Advanced Office Systems";
POPHdr.SUBTOTALSpecified =
true;
POPHdr.SUBTOTAL = 2;
POPHdr.DOCDATE =
"2007-04-14";
POPLine1.PONUMBER =
"PO2076";
POPLine1.VENDORID =
"Advanced0001";
POPLine1.ITEMNMBR =
"128 SDRAM";
POPLine1.ITEMDESC =
"128 meg SDRAM";
POPLine1.UOFM =
"Each";
POPLine1.QUANTITYSpecified =
true;
POPLine1.QUANTITY = 1;
POPLine1.UNITCOSTSpecified =
true;
POPLine1.UNITCOST = 2;
POPLine1.LOCNCODE =
"WAREHOUSE";
POPTransHdr.taPoHdr = POPHdr;
POPTransArray[0] = POPTransHdr;
POPLine[0] = POPLine1;
POPTransLine.taPoLine_Items = POPLine;
POPTransArray[1] = POPTransLine;
econtype.POPTransactionType = POPTransArray;
FileStream fs = new FileStream(@"E:\XML samples\POPEconnect.xml", fileMode.Create);
XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());
XmlSerializer serializer = new XmlSerializer(econtype.GetType());
serializer.Serialize(writer, econtype);
writer.Close();
fs.Close();
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(
@"E:\XML samples\POPEconnect.xml");
outxml = xmldoc.OuterXml;
 



Print Page | Close Window