DynDeveloper.com

Edit 9/16/15 View the main article for this error here  

 Hi,

I am new to GP and econnect. I am using Econnect10 evaluation version. I tried to save few quotes and orders from my appliccation to GP. But I am getting Document ID is invalid when I am trying to save Quote in to GP. But manually I am able to create a Quote with the same Doc Id in GP.

I am not able to find any solution for this issue. Please help me to resolve this issue.  Thanks for your help. I appreciate it.

The following is the error which I am getting.

Sql procedure error codes returned:

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

Node Identifier Parameters: taSopHdrIvcInsert                                 

SOPNUMBE = OR-00000005-00000004

SOPTYPE = 1

Related Error Code Parameters for Node : taSopHdrIvcInsert                                 

DOCID = QTE00000000000002

SOPTYPE = 1

<taSopHdrIvcInsert><SOPTYPE>1</SOPTYPE><DOCID>QTE00000000000002</DOCID><SOPNUMBE>OR-00000005-00000004</SOPNUMBE><DOCDATE>2009/02/16</DOCDATE><CUSTNMBR>CUS1</CUSTNMBR><DOCAMNT>206.00</DOCAMNT>

<BACHNUMB>BAT001</BACHNUMB><PRBTADCD>Test Add1</PRBTADCD><PRSTADCD>Test Add1</PRSTADCD><USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES><DEFPRICING>1</DEFPRICING></taSopHdrIvcInsert>

The following is the econnectxml

<?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\">

  <RMCustomerMasterType>

    <eConnectProcessInfo xsi:nil=\"true\" />

    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />

    <taUpdateCreateCustomerRcd>

      <CUSTNMBR>CUS1</CUSTNMBR>

      <CUSTNAME>Test User</CUSTNAME>

      <ADRSCODE>Test Add1</ADRSCODE>

      <PRSTADCD>Test Add1</PRSTADCD>

      <PRBTADCD>Test Add1</PRBTADCD>

    </taUpdateCreateCustomerRcd>

    <taCreateCustomerAddress_Items>

      <taCreateCustomerAddress>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <ADRSCODE>Test Add1</ADRSCODE>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHNUMBR1>96799923450000</PHNUMBR1>

      </taCreateCustomerAddress>

      <taCreateCustomerAddress>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <ADRSCODE>Test Add1</ADRSCODE>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHNUMBR1>96799923450000</PHNUMBR1>

      </taCreateCustomerAddress>

    </taCreateCustomerAddress_Items>

    <taCreateParentID xsi:nil=\"true\" />

    <taParentIDChild_Items xsi:nil=\"true\" />

  </RMCustomerMasterType>

  <CMPInternetAddressType>

    <eConnectProcessInfo xsi:nil=\"true\" />

    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />

    <taCreateInternetAddresses>

      <Master_Type>CUS</Master_Type>

      <Master_ID>CUS1</Master_ID>

      <ADRSCODE>Test Add1</ADRSCODE>

      <INET1>testuser@testuser.com</INET1>

    </taCreateInternetAddresses>

  </CMPInternetAddressType>

  <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 xsi:nil=\"true\" />

    <taSopLineIvcInsert_Items>

      <taSopLineIvcInsert>

        <SOPTYPE>1</SOPTYPE>

        <SOPNUMBE>OR-00000005-00000004</SOPNUMBE>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <DOCDATE>2009/02/16</DOCDATE>

        <ITEMNMBR>SKU Item 1</ITEMNMBR>

        <UNITPRCE>205.00</UNITPRCE>

        <QUANTITY>1</QUANTITY>

        <ITEMDESC>SKU Item 1</ITEMDESC>

        <PRSTADCD>Test Add1</PRSTADCD>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHONE1>96799923450000</PHONE1>

        <DEFEXTPRICE>1</DEFEXTPRICE>

      </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>1</SOPTYPE>

      <DOCID>QTE00000000000002</DOCID>

      <SOPNUMBE>OR-00000005-00000004</SOPNUMBE>

      <DOCDATE>2009/02/16</DOCDATE>

      <FREIGHT>1.00</FREIGHT>

      <TRDISAMT>0.00</TRDISAMT>

      <CUSTNMBR>CUS1</CUSTNMBR>

      <DOCAMNT>206.00</DOCAMNT>

      <BACHNUMB>BAT0001</BACHNUMB>

      <PRBTADCD>Test Add1</PRBTADCD>

      <PRSTADCD>Test Add1</PRSTADCD>

      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>

      <DEFPRICING>1</DEFPRICING>

    </taSopHdrIvcInsert>

    <taSopToPopLink xsi:nil=\"true\" />

    <taSopUpdateCreateProcessHold xsi:nil=\"true\" />

    <taCreateSOPTrackingInfo xsi:nil=\"true\" />

    <taMdaUpdate_Items xsi:nil=\"true\" />

  </SOPTransactionType>

</eConnect>