DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
joealt 3/4/2013 4:33:39 PM

taSopSerial error on update

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

Hi,

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

2905: Qty fulfilled can not exceed qty allocated

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

 

 This is the XML:

<?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.

Please can anyone help me?

Thanks.

Version: GP 2010
Section: eConnect