DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Peter 11/8/2007 1:11:08 PM

I get a "System Error" when attempting to add an invoice using eConnect

I have been struggling to figure out how to use the eConnect (version 9) assemblies to create a new invoice in our Dynamics GP 9 system.

However, when I send the XML to eConnect (using eConnect_EntryPoint), I get a System.Data.SqlClient.SqlException whose message is merely: "System Error". Not very helpful. The only other information it gives is the procedure name: taSopLineIvcInsert. It gives me the line number in the procedure, but I cannot open up the SP code because it is protected.

Here's the serialized XML I'm sending in via eConnect 9:

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOPTransactionType><eConnectProcessInfo xsi:nil="true" /><taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>PCTTEST1</SOPNUMBE>
<CUSTNMBR>PETE0003</CUSTNMBR>
<DOCDATE>11/8/2007 9:46:26 AM</DOCDATE>
<ITEMNMBR>WIDGIT</ITEMNMBR>
<UNITPRCE>3.25</UNITPRCE>
<XTNDPRCE>42.25</XTNDPRCE>
<QUANTITY>13</QUANTITY>
<PRCLEVEL>RETAIL</PRCLEVEL>
<DOCID>TESTDOC01</DOCID>
<UOFM>EACH</UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>TESTDOC01</DOCID>
<SOPNUMBE>PCTTEST1</SOPNUMBE>
<DOCDATE>11/8/2007 9:46:26 AM</DOCDATE>
<CUSTNMBR>PETE0003</CUSTNMBR>
<BACHNUMB />
<PRCLEVEL>RETAIL</PRCLEVEL>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect> 

Prior to this point, I was getting useful errors from eConnect about which specific fields I was or wasn't setting properly. However, once I resolved all those issues, I started getting the unhelpful System Error message.

Any ideas? I'm going crazy here.

Thanks in advance,

Peter


 

Version: Unknown or N/A
Section: eConnect