I'm trying to use the stored procedure taSopSerial to create and update returns.
The first time I save the document the procedure works fine - because the serial number has been selected yet. But when I try to update an existing return, I get several errors from taSopSerial:
1526: The Serial Number has already been sold - please choose another Serial Number
1532: The Serial Number (SERLNMBR) has already been selected for the entered item - Edit 9/16/15 View the main article for this error here
<?xml version="1.0"?>
<SOPTransactionType>
<eConnectProcessInfo>
<ProductName>SalesPad GP</ProductName>
</eConnectProcessInfo>
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items>
<taSopSerial>
<SOPTYPE>4</SOPTYPE>
<SOPNUMBE>RTN1223</SOPNUMBE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>100XLG</ITEMNMBR>
<BIN>RETN</BIN>
<SERLNMBR>00969</SERLNMBR>
<DOCID>RTN</DOCID>
<UpdateIfExists>1</UpdateIfExists>
</taSopSerial>
</taSopSerial_Items>
<taSopLotAuto_Items />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>4</SOPTYPE>
<SOPNUMBE>RTN1223</SOPNUMBE>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<DOCDATE>3/4/2013</DOCDATE>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<ITEMNMBR>100XLG</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>59.95000</UNITPRCE>
<XTNDPRCE>59.95000000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<MRKDNPCT>0</MRKDNPCT>
<UNITCOST>55.50000</UNITCOST>
<PRCLEVEL>RETAIL</PRCLEVEL>
<ITEMDESC>Green Phone 6</ITEMDESC>
<QTYONHND>1</QTYONHND>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>RTN</DOCID>
<SALSTERR>TERRITORY 1</SALSTERR>
<SLPRSNID>PAUL W.</SLPRSNID>
<ITMTSHID>USASTCITY-6*</ITMTSHID>
<TAXSCHID>USASTCITY-6*</TAXSCHID>
<PRSTADCD>WAREHOUSE</PRSTADCD>
<ShipToName>Aaron Fitz Electrical</ShipToName>
<CNTCPRSN>Bob Fitz</CNTCPRSN>
<ADDRESS1>11403 45 St. South</ADDRESS1>
<CITY>Chicago</CITY>
<STATE>IL</STATE>
<ZIPCODE>60603-0776</ZIPCODE>
<COUNTRY>USA</COUNTRY>
<PHONE1>3125550102</PHONE1>
<PHONE2>3125550102</PHONE2>
<FAXNUMBR>3125550102</FAXNUMBR>
<ReqShipDate>3/4/2013</ReqShipDate>
<ACTLSHIP>1/1/1900</ACTLSHIP>
<SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
<UpdateIfExists>1</UpdateIfExists>
<CURNCYID>Z-US$</CURNCYID>
<UOFM>EACH</UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined>
<SOPTYPE>4</SOPTYPE>
<SOPNUMBE>RTN1223</SOPNUMBE>
<USRTAB01>TEST12</USRTAB01>
</taSopUserDefined>
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items />
<taSopHdrIvcInsert>
<SOPTYPE>4</SOPTYPE>
<DOCID>RTN</DOCID>
<SOPNUMBE>RTN1223</SOPNUMBE>
<TAXSCHID>USASTCITY-6*</TAXSCHID>
<SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<DOCDATE>3/4/2013</DOCDATE>
<TRDISAMT>0.00000</TRDISAMT>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<CUSTNAME>Aaron Fitz Electrical</CUSTNAME>
<ShipToName>Aaron Fitz Electrical</ShipToName>
<ADDRESS1>11403 45 St. South</ADDRESS1>
<CNTCPRSN>Bob Fitz</CNTCPRSN>
<FAXNUMBR>3125550102</FAXNUMBR>
<CITY>Chicago</CITY>
<STATE>IL</STATE>
<ZIPCODE>60603-0776</ZIPCODE>
<COUNTRY>USA</COUNTRY>
<PHNUMBR1>3125550102</PHNUMBR1>
<PHNUMBR2>3125550102</PHNUMBR2>
<SUBTOTAL>59.95000</SUBTOTAL>
<DOCAMNT>59.95000000</DOCAMNT>
<SALSTERR>TERRITORY 1</SALSTERR>
<SLPRSNID>PAUL W.</SLPRSNID>
<USER2ENT>fredericp</USER2ENT>
<BACHNUMB>RETURN</BACHNUMB>
<PRBTADCD>PRIMARY</PRBTADCD>
<PRSTADCD>WAREHOUSE</PRSTADCD>
<CREATECOMM>1</CREATECOMM>
<CREATETAXES>1</CREATETAXES>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<CURNCYID>Z-US$</CURNCYID>
<ReqShipDate>3/4/2013</ReqShipDate>
<UpdateExisting>1</UpdateExisting>
<PRCLEVEL>RETAIL</PRCLEVEL>
<DEFPRICING>1</DEFPRICING>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>
I thought setting UpdateIfExists = 1 would be enough but apparently it's not. I tried adding other fields (for example AUTOCREATESERIAL, SERLNMBRToReplace), but I still get errors.
Thanks.