Some more information on the error Helen is seeing.
We are using GP Dynamics versioon 12.00.1042 (RTM), Deterity 12.00.0107.000, eConnect 12.1.1045.0
This is the Beta version. We just got the full version, and will be testing this on that version.
The error is on a fresh GP 2013 install, using the same code and xml we used with GP 2010. We are trying to create a SalesOrder in GP.
Here is the error trace...
System.Data.SqlClient.SqlException (0x80131904): Procedure or function taSopLineIvcInsertPre has too many arguments specified.
at Microsoft.Dynamics.GP.eConnect.ServiceProxy.HandleSqlException(FaultException`1 ex)
at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)
Here is the xml we are passing to eConnect function CreateTransactionEntity()...
<eConnect xmlns:dt="urn:schemas-microsoftcom:datatypes">
<SOPTransactionType>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPNUMBE>ORDST2235</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<CUSTNMBR>ADAMPARK0001</CUSTNMBR>
<DOCDATE>2010-02-04</DOCDATE>
<ITEMNMBR>256SDRAM</ITEMNMBR>
<UNITPRCE>12.4</UNITPRCE>
<XTNDPRCE>74.4</XTNDPRCE>
<QUANTITY>6</QUANTITY>
<ITEMDESC>256meg SDRAM</ITEMDESC>
<DEFPRICING>1</DEFPRICING>
<QtyShrtOpt>2</QtyShrtOpt>
<NONINVEN>0</NONINVEN>
<ReqShipDate>2010-02-19</ReqShipDate>
<CURNCYID>Z-US$</CURNCYID>
<DROPSHIP>1</DROPSHIP>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPNUMBE>ORDST2235</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<CUSTNMBR>ADAMPARK0001</CUSTNMBR>
<DOCDATE>2010-02-04</DOCDATE>
<ITEMNMBR>4.5HD</ITEMNMBR>
<UNITPRCE>12.4</UNITPRCE>
<XTNDPRCE>24.8</XTNDPRCE>
<QUANTITY>2</QUANTITY>
<ITEMDESC>4.5 gig Hard Drive</ITEMDESC>
<DEFPRICING>1</DEFPRICING>
<QtyShrtOpt>2</QtyShrtOpt>
<NONINVEN>0</NONINVEN>
<ReqShipDate>2010-02-19</ReqShipDate>
<CURNCYID>Z-US$</CURNCYID>
<DROPSHIP>1</DROPSHIP>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopHdrIvcInsert>
<SOPNUMBE>ORDST2235</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<DOCID>STDORD</DOCID>
<DOCDATE>2010-02-04</DOCDATE>
<CUSTNMBR>ADAMPARK0001</CUSTNMBR>
<CSTPONBR>JE98765-1234</CSTPONBR>
<SUBTOTAL>99.2</SUBTOTAL>
<DOCAMNT>99.2</DOCAMNT>
<BACHNUMB>EDI12/25/2012</BACHNUMB>
<PRSTADCD>PRIMARY</PRSTADCD>
<ORDRDATE>2010-02-04</ORDRDATE>
<CREATETAXES>1</CREATETAXES>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<DEFPRICING>1</DEFPRICING>
<ReqShipDate>2010-02-19</ReqShipDate>
</taSopHdrIvcInsert>
<taSopUserDefined>
<SOPNUMBE>ORDST2235</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<USRDEF03>PATTERSON</USRDEF03>
</taSopUserDefined>
<TCEDI>
<StoreNumber>PD089031157</StoreNumber>
<DCCode>TCEDI</DCCode>
<MarkForCode>TCEDI</MarkForCode>
<DepartmentNumber>TCEDI</DepartmentNumber>
<User1>TCEDI</User1>
<User2>TCEDI</User2>
</TCEDI></SOPTransactionType>
</eConnect>
