Skip to content
+1-888-319-3663

COMMUNITY FORUM

GP_ORDERS_RT Map Template Issues

Yassin asked 3 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>
 
Answers
Ethan Sorenson Staff answered 3 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.

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