Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
joelee 8/28/2013 12:19:27 PM

SOP Transaction with Lots using eConnect

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

Hi all.

I'm trying to integrate the lots functionality to my app using eConnect.

This is the xml document I'm generating:

<?xml version="1.0" encoding="utf-16"?>
    <SOPTransactionType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateItemRcd xsi:nil="true"/>
        <taUpdateCreateCustomerRcd xsi:nil="true"/>
        <taCreateCustomerAddress_Items xsi:nil="true"/>
        <taSopSerial_Items xsi:nil="true"/>
        <taSopLotAuto_Items>
            <taSopLotAuto>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INVSB2_10001</SOPNUMBE>
                <LNITMSEQ>0</LNITMSEQ>
                <ITEMNMBR>0000000840</ITEMNMBR>
                <LOCNCODE>MAIN</LOCNCODE>
                <QUANTITY>1</QUANTITY>
                <QTYFULFI>1</QTYFULFI>
                <ALLOCATE>1</ALLOCATE>
            </taSopLotAuto>
        </taSopLotAuto_Items>
        <taSopLineIvcInsert_Items>
            <taSopLineIvcInsert>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>INVSB2_10001</SOPNUMBE>
                <CUSTNMBR>000223</CUSTNMBR>
                <DOCDATE>8/26/2013</DOCDATE>
                <LOCNCODE>MAIN</LOCNCODE>
                <ITEMNMBR>0000000840</ITEMNMBR>
                <UNITPRCE>12.00000</UNITPRCE>
                <XTNDPRCE>12.00</XTNDPRCE>
                <QUANTITY>1.000000</QUANTITY>
                <PRCLEVEL>EXTPRCLVL</PRCLEVEL>
                <ITEMDESC>Lot Number</ITEMDESC>
                <SALSTERR>POS            </SALSTERR>
                <SLPRSNID>POS</SLPRSNID>
                <IVITMTXB>1</IVITMTXB>
                <TAXSCHID>STATE</TAXSCHID>
                <PRSTADCD>MAIN</PRSTADCD>
                <ReqShipDate>8/26/2013</ReqShipDate>
                <FUFILDAT>8/26/2013</FUFILDAT>
                <ACTLSHIP>8/26/2013</ACTLSHIP>
                <SHIPMTHD>EXPRESS MAIL   </SHIPMTHD>
                <AUTOALLOCATELOT>1</AUTOALLOCATELOT>
                <QTYFULFI>1.000000</QTYFULFI>
                <CURNCYID>Z-US$</CURNCYID>
                <UOFM>1</UOFM>
            </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>
            <SOPTYPE>3</SOPTYPE>
            <SOPNUMBE>INVSB2_10001</SOPNUMBE>
            <USRDAT01>1/1/1900</USRDAT01>
            <USRDAT02>1/1/1900</USRDAT02>
            <USRTAB01>Local</USRTAB01>
            <USRDEF03>.</USRDEF03>
        </taSopUserDefined>
        <taSopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taSopMultiBin_Items xsi:nil="true"/>
        <taSopHdrIvcInsert>
            <SOPTYPE>3</SOPTYPE>
            <DOCID>INVOICE</DOCID>
            <SOPNUMBE>INVSB2_10001</SOPNUMBE>
            <TAXSCHID>STATE</TAXSCHID>
            <SHIPMTHD>EXPRESS MAIL   </SHIPMTHD>
            <LOCNCODE>MAIN</LOCNCODE>
            <DOCDATE>8/26/2013</DOCDATE>
            <CUSTNMBR>000223</CUSTNMBR>
            <CUSTNAME>Matos Vega, Vicenteaaaaaaaaaaaaaaaaa</CUSTNAME>
            <ShipToName>MATOS VEGA, VICENTE</ShipToName>
            <ADDRESS1>PLANTA FISICA</ADDRESS1>
            <FAXNUMBR>00000000000000</FAXNUMBR>
            <PHNUMBR1>00000000000000</PHNUMBR1>
            <PHNUMBR2>00000000000000</PHNUMBR2>
            <PHNUMBR3>00000000000000</PHNUMBR3>
            <SUBTOTAL>12.00</SUBTOTAL>
            <DOCAMNT>12.84</DOCAMNT>
            <SALSTERR>POS            </SALSTERR>
            <SLPRSNID>POS</SLPRSNID>
            <USER2ENT>IPAD</USER2ENT>
            <BACHNUMB>1-20130826</BACHNUMB>
            <PRBTADCD>MAIN</PRBTADCD>
            <PRSTADCD>MAIN</PRSTADCD>
            <DUEDATE>8/26/2013</DUEDATE>
            <CREATECOMM>1</CREATECOMM>
            <CREATETAXES>1</CREATETAXES>
            <CURNCYID>Z-US$</CURNCYID>
            <ReqShipDate>8/26/2013</ReqShipDate>
            <CKHOLD>1</CKHOLD>
            <PRCLEVEL>DEFAULT</PRCLEVEL>
            <DEFPRICING>1</DEFPRICING>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true"/>
        <taSopUpdateCreateProcessHold xsi:nil="true"/>
        <taCreateSOPTrackingInfo xsi:nil="true"/>
        <taMdaUpdate_Items xsi:nil="true"/>
    </SOPTransactionType>
    <SOPProcessHoldType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taSopUpdateCreateProcessHold>
            <SOPTYPE>3</SOPTYPE>
            <SOPNUMBE>INVSB2_10001</SOPNUMBE>
            <PRCHLDID>Credit</PRCHLDID>
            <DELETE1>1</DELETE1>
            <UpdateSopIfExists>1</UpdateSopIfExists>
        </taSopUpdateCreateProcessHold>
    </SOPProcessHoldType>
    <SOPProcessHoldType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taSopUpdateCreateProcessHold>
            <SOPTYPE>3</SOPTYPE>
            <SOPNUMBE>INVSB2_10001</SOPNUMBE>
            <PRCHLDID>Price</PRCHLDID>
            <DELETE1>1</DELETE1>
            <UpdateSopIfExists>1</UpdateSopIfExists>
        </taSopUpdateCreateProcessHold>
    </SOPProcessHoldType>
</eConnect>
 

But I keep getting this error:

Sql procedure error codes returned: 

 

Error Number = 2305  Stored Procedure= taSopLineIvcInsert  Error Description = if AUTOALLOCATELOT = 1 or 2, the taSopLotAuto node must be called with a DOCID that fulfills or QTYFULFI > 0

Node Identifier Parameters: taSopLineIvcInsert

SOPNUMBE = INVSB2_10001

SOPTYPE = 3

Related Error Code Parameters for Node : taSopLineIvcInsert

AUTOALLOCATELOT = 1

 

Error Number = 4730  Stored Procedure= taSopLineIvcInsert  Error Description = AUTOALLOCATELOT = 1 and the SOP10101 qty fulfilled does not match the Sop Line fulfilled

Node Identifier Parameters: taSopLineIvcInsert

SOPNUMBE = INVSB2_10001

SOPTYPE = 3

Related Error Code Parameters for Node : taSopLineIvcInsert

AUTOALLOCATELOT = 1

 

I'm completely lost, any ideas?

Thank you very much!

Version: GP 2013
Section: .NET Development, Dynamics GP, 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