GP_ORDERS_RT Map Template Issues
Yassin asked 5 years ago
I am trying to integration CRM orders into GP using the SmartConnect GP_ORDERS_RT Map as start and using the CRM order number on the SOP Document number but keep getting the following
GP_ORDERS_RT: Sql procedure error codes returned:
Error Number = 2221 Stored Procedure= taSopLineIvcInsert Error Description = Duplicate document number. If adding or updating lines to an existing document, UpdateIfExists must = 1
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = ORD-01021-D9D7M1
SOPTYPE = 2
Related Error Code Parameters for Node : taSopLineIvcInsert
UpdateIfExists = 0
<taSopLineIvcInsert>
<LOCNCODE>PLYMOUTH</LOCNCODE>
<CUSTNMBR>25848</CUSTNMBR>
<SOPNUMBE>ORD-01021-D9D7M1</SOPNUMBE>
<QUANTITY>1.0000000000</QUANTITY>
<ITEMNMBR>DIS603ENG42</ITEMNMBR>
<SOPTYPE>2</SOPTYPE>
<UNITPRCE>60.0000</UNITPRCE>
<DEFEXTPRICE>1</DEFEXTPRICE>
<UpdateIfExists>0</UpdateIfExists>
<DOCDATE>09/19/2018</DOCDATE>
</taSopLineIvcInsert>
GP_ORDERS_RT: Sql procedure error codes returned:
Error Number = 2221 Stored Procedure= taSopLineIvcInsert Error Description = Duplicate document number. If adding or updating lines to an existing document, UpdateIfExists must = 1
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = ORD-01021-D9D7M1
SOPTYPE = 2
Related Error Code Parameters for Node : taSopLineIvcInsert
UpdateIfExists = 0
<taSopLineIvcInsert>
<LOCNCODE>PLYMOUTH</LOCNCODE>
<CUSTNMBR>25848</CUSTNMBR>
<SOPNUMBE>ORD-01021-D9D7M1</SOPNUMBE>
<QUANTITY>1.0000000000</QUANTITY>
<ITEMNMBR>DIS603ENG42</ITEMNMBR>
<SOPTYPE>2</SOPTYPE>
<UNITPRCE>60.0000</UNITPRCE>
<DEFEXTPRICE>1</DEFEXTPRICE>
<UpdateIfExists>0</UpdateIfExists>
<DOCDATE>09/19/2018</DOCDATE>
</taSopLineIvcInsert>
Answers
Ethan Sorenson Staff answered 4 years ago
The issue here was the Update Existing flag was set to 0(Create Only) and was causing the map to fail whenever an edit was made to the order in CRM. Real-Time triggers can be put on Creates or Updates. Yassin needed to switch to Create only triggers.