Edit 9/16/15 View the main article for this error here
hello, I am trying post below xml for creating Sales Invoice but getting Document ID is invalid, I tried to create the same invoice in GP and it works fine.. I tried changing various Document ID but no success. any idea would be great help?
Error Number = 68 Stored Procedure= taSopHdrIvcInsert Error Description = Document ID is invalid
Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = JW-1106-339
SOPTYPE = 3
Related Error Code Parameters for Node : taSopHdrIvcInsert
DOCID = 28166
SOPTYPE = 3
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>28166</DOCID>
<SOPNUMBE>JW-1106-339</SOPNUMBE>
<DOCDATE>2014-11-06</DOCDATE>
<CUSTNMBR>01160</CUSTNMBR>
<SUBTOTAL>500</SUBTOTAL>
<BACHNUMB>LAMSUPP</BACHNUMB>
</taSopHdrIvcInsert>
---> Microsoft.Dynamics.GP.eConnect.eConnectException: Error Number = 68 Stored Procedure taSopHdrIvcInsert Error Description = Document ID is invalid
--- End of inner exception stack trace ---
at Microsoft.Dynamics.GP.eConnect.EntityMessageProcessor.ExecuteSqlCommands(XElement transactionNode, EntityMessage message)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessMessageImport(EntityMessage message)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)
at DLCGP.Connection.SendMessage() in d:\DLC\DLCGP\DLCGP\Connection.cs:line 61
2014-11-06 15:27:34,765 [36] DEBUG DLCGP.Logger - DLCGP : Leaving the Sales Invoice Create
XML Message:
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items>
<taSopLotAuto>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>JW-1106-339</SOPNUMBE>
<LNITMSEQ>0</LNITMSEQ>
<ITEMNMBR>1007</ITEMNMBR>
<LOCNCODE>AT SEA</LOCNCODE>
<QUANTITY>2</QUANTITY>
<LOTNUMBR>JW-110</LOTNUMBR>
<UOFM>BAG</UOFM>
</taSopLotAuto>
</taSopLotAuto_Items>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>JW-1106-339</SOPNUMBE>
<CUSTNMBR>01160</CUSTNMBR>
<DOCDATE>2014-11-06</DOCDATE>
<LOCNCODE>AT SEA</LOCNCODE>
<ITEMNMBR>1007</ITEMNMBR>
<UNITPRCE>250</UNITPRCE>
<XTNDPRCE>500</XTNDPRCE>
<QUANTITY>2</QUANTITY>
<UOFM>BAG</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" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>28166</DOCID>
<SOPNUMBE>JW-1106-339</SOPNUMBE>
<DOCDATE>2014-11-06</DOCDATE>
<CUSTNMBR>01160</CUSTNMBR>
<SUBTOTAL>500</SUBTOTAL>
<BACHNUMB>LAMSUPP</BACHNUMB>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>