DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
111consulting 11/6/2014 6:30:52 PM

Error Number = 68 Stored Procedure= taSopHdrIvcInsert Error Description = Document ID is invalid

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>

Version: GP 2010
Section: Dynamics GP, eConnect