Skip to content
+1-888-319-3663

COMMUNITY FORUM

Order not going from CRM to GP

Tony Iacono asked 7 years ago
STR_GP_ORDERS_RT: Sql procedure error codes returned:
Error Number = 56 Stored Procedure= taSopHdrIvcInsert Error Description = Input variable contains a duplicate document
Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = ORD-01046-G1B6L1
SOPTYPE = 2
Related Error Code Parameters for Node : taSopHdrIvcInsert
SOPNUMBE = ORD-01046-G1B6L1
SOPTYPE = 2

<taSopHdrIvcInsert>
<UpdateIfExists>1</UpdateIfExists>
<TRDISAMT>0.0000</TRDISAMT>
<SOPNUMBE>ORD-01046-G1B6L1</SOPNUMBE>
<FREIGHT></FREIGHT>
<BACHNUMB>CRMBAT0001</BACHNUMB>
<ADDRESS2></ADDRESS2>
<COUNTRY></COUNTRY>
<CUSTNMBR>WILSONBROWN0001</CUSTNMBR>
<ADDRESS1></ADDRESS1>
<ORIGNUMB>ORD-01046-G1B6L1</ORIGNUMB>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<ADDRESS3></ADDRESS3>
<SHIPMTHD></SHIPMTHD>
<CITY></CITY>
<PHNUMBR1></PHNUMBR1>
<SOPTYPE>2</SOPTYPE>
<ShipToName></ShipToName>
<DEFPRICING>1</DEFPRICING>
<UpdateExisting>0</UpdateExisting>
<CSTPONBR>0000003</CSTPONBR>
<CUSTNAME>Wilson Brown</CUSTNAME>
<INTEGRATIONID>CRM</INTEGRATIONID>
<DOCID>STDORD</DOCID>
<DOCDATE>3/22/2015 12:00:00 AM</DOCDATE>
</taSopHdrIvcInsert>
Answers
patrick answered 7 years ago
duplicate.
Tony Iacono replied 7 years ago

Why can’t it or doesn’t update if it’s already there?


If you would like to submit an answer or comment, please sign in to the eOne portal.