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