rajibaba 6/23/2008 1:21:02 PM

Errors posting a sales return through eConnect/GP9

Edit 9/16/15 View the main article for this error here 

I'm trying to post a return through eConnect, but I receive the following errors:

Error Number = 1526  Stored Procedure taSopSerial  Error Description = The Serial Number has already been sold - please choose another Serial Number

Error Number = 2905  Stored Procedure taSopSerial  Error Description = Qty fulfilled can not exceed qty allocated

Edit 9/16/15 View the main article for this error here 

Error Number = 1532  Stored Procedure taSopSerial  Error Description = The Serial Number (SERLNMBR) has already been selected for the entered item

Not really sure what to make of the errors.  The first error mentions that the serial has been sold.  This is true, but it is being returned so I don't see how that is relevant.  As for the quantity, I specified in GP that one item would be returned, and specified the serial number.  Only one item is being returned, and the serial number in the taSopSerial matches the serial specified on the return in GP.  The following is the XML that is being sent up:

 

<?xml version="1.0" encoding="utf-8" ?>
- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <SOPTransactionType>
- <eConnectProcessInfo>
  <ProductName>GP eConnect Interface</ProductName>
  <Version>9.0</Version>
  </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>RTN0008</SOPNUMBE>
  <LNITMSEQ>16384</LNITMSEQ>
  <QTYTYPE>2</QTYTYPE>
  <ITEMNMBR>TEST_SER</ITEMNMBR>
  <LOCNCODE>Warehouse</LOCNCODE>
  <SERLNMBR>4</SERLNMBR>
  <DOCID>RTN</DOCID>
  <UpdateIfExists>1</UpdateIfExists>
  </taSopSerial>
  </taSopSerial_Items>
  <taSopLotAuto_Items xsi:nil="true" />
- <taSopLineIvcInsert_Items>
- <taSopLineIvcInsert>
  <SOPTYPE>4</SOPTYPE>
  <SOPNUMBE>RTN0008</SOPNUMBE>
  <CUSTNMBR>TESTCUST</CUSTNMBR>
  <DOCDATE>6/23/2008</DOCDATE>
  <LOCNCODE>Warehouse</LOCNCODE>
  <ITEMNMBR>TEST_SER</ITEMNMBR>
  <UNITPRCE>2.50</UNITPRCE>
  <QUANTITY>1.0000000</QUANTITY>
  <MRKDNAMT>0.00</MRKDNAMT>
  <UNITCOST>2.50</UNITCOST>
  <QTYONHND>1.0000000</QTYONHND>
  <LNITMSEQ>16384</LNITMSEQ>
  <DOCID>RTN</DOCID>
  <INVINDX>000-1300-02</INVINDX>
  <CSLSINDX>000-4510-02</CSLSINDX>
  <SLSINDX>000-4190-00</SLSINDX>
  <MKDNINDX>000-1205-00</MKDNINDX>
  <RTNSINDX>000-1330-02</RTNSINDX>
  <INUSINDX>000-1520-00</INUSINDX>
  <INSRINDX>000-1300-02</INSRINDX>
  <DMGDINDX>000-4700-00</DMGDINDX>
  <UpdateIfExists>1</UpdateIfExists>
  <DEFEXTPRICE>1</DEFEXTPRICE>
  </taSopLineIvcInsert>
  </taSopLineIvcInsert_Items>
  <taSopLineIvcInsertComponent_Items xsi:nil="true" />
  <taSopTrackingNum_Items xsi:nil="true" />
  <taSopCommissions_Items xsi:nil="true" />
  <taSopLineIvcTaxInsert_Items xsi:nil="true" />
  <taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
  <taSopUserDefined xsi:nil="true" />
  <taSopDistribution_Items xsi:nil="true" />
  <taSopMultiBin_Items xsi:nil="true" />
- <taSopHdrIvcInsert>
  <SOPTYPE>4</SOPTYPE>
  <DOCID>RTN</DOCID>
  <SOPNUMBE>RTN0008</SOPNUMBE>
  <LOCNCODE>Warehouse</LOCNCODE>
  <DOCDATE>6/23/2008 12:00:00 AM</DOCDATE>
  <CUSTNMBR>TESTCUST</CUSTNMBR>
  <BACHNUMB>ADMIN</BACHNUMB>
  <ORDRDATE>6/23/2008</ORDRDATE>
  <UpdateExisting>1</UpdateExisting>
  </taSopHdrIvcInsert>
  <taSopToPopLink xsi:nil="true" />
  <taSopUpdateCreateProcessHold xsi:nil="true" />
  <taCreateSOPTrackingInfo xsi:nil="true" />
  <taMdaUpdate_Items xsi:nil="true" />
  </SOPTransactionType>
  </eConnect>
 
Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3