Share
Report
82Hi,
I was using eConnect to update a sales order's requested ship date into database, both the header and line.
I found that within the right value in eConnect XML, there's nothing changed in database.
But i used the same way to update actual ship date and found that actual ship date can be updated into database.
I am looking for help to know if this could be my mistake or the database locks updating request ship date in this way.
Thanks!
the eConnect XML is as below,
<eConnect p1:xmlnsdt=""
xmlns:p1="urn:schemas-microsoft-com:datatypes">
<SOPTransactionType>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>STDORD</DOCID>
<SOPNUMBE>ORDST2272</SOPNUMBE>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<DOCDATE>04/12/2027</DOCDATE>
<QUANTITY>2</QUANTITY>
<QTYFULFI>1</QTYFULFI>
<QTYCANCE>0</QTYCANCE>
<TOTALQTY>2.00000</TOTALQTY>
<ITEMNMBR>100XLG</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<ACTLSHIP></ACTLSHIP>
<UpdateIfExists>1</UpdateIfExists>
<ALLOCATE>1</ALLOCATE>
<USRDEFND5>TC_Lot</USRDEFND5>
<SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
<ReqShipDate>10/02/2027</ReqShipDate>
<ACTLSHIP>10/02/2027</ACTLSHIP>
<UNITPRCE>0</UNITPRCE>
<UOFM>Each</UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopHdrIvcInsert>
<SOPNUMBE>ORDST2272</SOPNUMBE>
<BACHNUMB>TEST</BACHNUMB>
<DOCDATE>04/12/2027</DOCDATE>
<DOCID>STDORD</DOCID>
<SOPTYPE>2</SOPTYPE>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<UpdateExisting>1</UpdateExisting>
<USRDEFND5>TC_Lot</USRDEFND5>
<SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
<ReqShipDate>10/02/2027</ReqShipDate>
<ACTLSHIP>10/02/2027</ACTLSHIP>
</taSopHdrIvcInsert>
<taSopUserDefined>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ORDST2272</SOPNUMBE>
</taSopUserDefined>
</SOPTransactionType>
</eConnect>
the data in database is as below,
*This post is locked for comments
All responses (
Answers (
