Site Search:
Sign in | Join | Help

Errors posting a sales return through eConnect/GP9

Last post 06-25-2008 1:49 PM by rajibaba. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-23-2008 1:21 PM

    Errors posting a sales return through eConnect/GP9

    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

    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>
     
    • 64.56.103.42
  • 06-24-2008 8:26 AM In reply to

    Re: Errors posting a sales return through eConnect/GP9

    The doc looks basically right. I have two ideas:

    1. Remove all the 'update existing' code. That acts funny sometimes.

    2. Go into Dynamics and manually key this doc. Be sure that you key the serial. If it doesn't let you key the serial... that's your problem.

    Steve Gray, MCDBA
    Technical Editor
    steve@VSToolsForum.com
    • 216.64.79.2
  • 06-25-2008 1:49 PM In reply to

    Re: Errors posting a sales return through eConnect/GP9

    Thanks for the reply.  Perhaps this is just a problem with my understanding of GP and eConnect, but basically I have already keyed in this return in GP. The purpose of the XML I'm sending is to verify that the return item has been received at the warehouse, essentially "fulfilling" the return.  I realize that GP allows the return to be posted as soon as the return is created, but is there no way to update the return to verify that it has been received?

    • 64.56.103.42
Page 1 of 1 (3 items)