Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - eConnect 10.0 POP Transaction
  FAQ FAQ  Forum Search   Register Register  Login Login


eConnect 10.0 POP Transaction

 Post Reply Post Reply
Author
Message
balajid View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: June 27 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote balajid Quote  Post ReplyReply Direct Link To This Post Topic: eConnect 10.0 POP Transaction
    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;
 
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com