Hi,
Re: GP2018 econnect
What is the difference between the eConnect stored procedures taSopLot and taSopLotAuto?
taSopLineIvcInsertComponent executes taSopLot.
taSopLotAuto is called through econnect (i.e., no separate dependencies).
We have found that both taSopLotAuto and taSopLot are executed when fulfilling kit components that have lot number tracking enabled.
In our case, they both update IV00300.ATYALLOC with the update below, which results in this value being doubled.
UPDATE IV00300
SET ATYALLOC=ATYALLOC+@QtyAvail, LTNUMSLD=CASE WHEN @QTYRECVD=@ATYALLOC+@QtyAvail+@QTYSOLD THEN 1 ELSE 0 END
FROM IV00300(UPDLOCK)
WHERE ITEMNMBR=@I_vITEMNMBR AND LOCNCODE=@I_vLOCNCODE AND LOTNUMBR=@I_vLOTNUMBR AND DATERECD=@I_vDATERECD AND DTSEQNUM=@DTSEQNUM AND QTYTYPE=@I_vQTYTYPE;
Thank you!
Our eConnect XML:
<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<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>INVSP1067</SOPNUMBE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>CAP300</ITEMNMBR>
<LOCNCODE>WNC</LOCNCODE>
<QUANTITY>6.0</QUANTITY>
<BIN>2030</BIN>
<LOTNUMBR>01222024</LOTNUMBR>
<CMPNTSEQ>16384</CMPNTSEQ>
</taSopLotAuto>
</taSopLotAuto_Items>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067 </SOPNUMBE>
<CUSTNMBR>CENTERSU0001 </CUSTNMBR>
<DOCDATE>1/23/2024 12:00:00 AM</DOCDATE>
<LOCNCODE>WNC</LOCNCODE>
<ITEMNMBR>KIT-CAP300 </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>20.00000</UNITPRCE>
<XTNDPRCE>20.00000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID> </COMMNTID>
<PRCLEVEL>RETAIL </PRCLEVEL>
<ITEMDESC>Kit Item 1 </ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<SALSTERR>TERRITORY 4 </SALSTERR>
<SLPRSNID>SANDRA M. </SLPRSNID>
<ITMTSHID> </ITMTSHID>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID>USASTCITY-6* </TAXSCHID>
<PRSTADCD>PRIMARY </PRSTADCD>
<ShipToName>Center Suite Hotel </ShipToName>
<CNTCPRSN>Mitch Payne </CNTCPRSN>
<ADDRESS1>8765 51 Ave S </ADDRESS1>
<ADDRESS2> </ADDRESS2>
<ADDRESS3> </ADDRESS3>
<CITY>Minneapolis </CITY>
<STATE>MN </STATE>
<ZIPCODE>55401-7694 </ZIPCODE>
<COUNTRY>USA </COUNTRY>
<PHONE1>80055501190000 </PHONE1>
<PHONE2>61255501190000 </PHONE2>
<PHONE3> </PHONE3>
<FAXNUMBR>61255501190000 </FAXNUMBR>
<ReqShipDate>1/23/2024 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>GROUND </SHIPMTHD>
<INVINDX>000-1300-01 </INVINDX>
<CSLSINDX>000-4510-01 </CSLSINDX>
<SLSINDX>000-4110-01 </SLSINDX>
<MKDNINDX>000-4180-00 </MKDNINDX>
<RTNSINDX>000-1330-01 </RTNSINDX>
<INUSINDX>000-1520-00 </INUSINDX>
<INSRINDX>000-1300-01 </INSRINDX>
<DMGDINDX>000-4700-00 </DMGDINDX>
<GPSFOINTEGRATIONID> </GPSFOINTEGRATIONID>
<INTEGRATIONID> </INTEGRATIONID>
<QTYFULFI>1.00000</QTYFULFI>
<UpdateIfExists>1</UpdateIfExists>
<CURNCYID>Z-US$ </CURNCYID>
<UOFM>Each </UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items>
<taSopLineIvcInsertComponent>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067 </SOPNUMBE>
<LOCNCODE>WNC</LOCNCODE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>CAP300</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<QUANTITY>6.0</QUANTITY>
<QTYFULFI>6.0</QTYFULFI>
<CUSTNMBR>CENTERSU0001 </CUSTNMBR>
<DOCID>SPECINV </DOCID>
<AUTOALLOCATELOT>1</AUTOALLOCATELOT>
<CMPNTSEQ>16384</CMPNTSEQ>
<CMPITUOM>Each </CMPITUOM>
<UpdateIfExists>1</UpdateIfExists>
</taSopLineIvcInsertComponent>
</taSopLineIvcInsertComponent_Items>
<taSopTrackingNum_Items>
<taSopTrackingNum>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067 </SOPNUMBE>
<Tracking_Number>12345</Tracking_Number>
</taSopTrackingNum>
</taSopTrackingNum_Items>
<taSopCommissions_Items xsi:nil="true"/>
<taSopLineIvcTaxInsert_Items xsi:nil="true"/>
<taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>
<taSopUserDefined>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067 </SOPNUMBE>
<USERDEF2>DN</USERDEF2>
<USRDEF05>1.0 - 1.1</USRDEF05>
</taSopUserDefined>
<taSopDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taSopMultiBin_Items/>
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>SPECINV </DOCID>
<SOPNUMBE>INVSP1067 </SOPNUMBE>
<SHIPMTHD>GROUND </SHIPMTHD>
<DOCDATE>1/23/2024 12:00:00 AM</DOCDATE>
<CUSTNMBR>CENTERSU0001 </CUSTNMBR>
<CSTPONBR> </CSTPONBR>
<ADDRESS1>8765 51 Ave S </ADDRESS1>
<ADDRESS2> </ADDRESS2>
<ADDRESS3> </ADDRESS3>
<CNTCPRSN>Mitch Payne </CNTCPRSN>
<FAXNUMBR>61255501190000 </FAXNUMBR>
<CITY>Minneapolis </CITY>
<STATE>MN </STATE>
<ZIPCODE>55401-7694 </ZIPCODE>
<COUNTRY>USA </COUNTRY>
<PHNUMBR1>80055501190000 </PHNUMBR1>
<PHNUMBR2>61255501190000 </PHNUMBR2>
<PHNUMBR3> </PHNUMBR3>
<SALSTERR>TERRITORY 4 </SALSTERR>
<SLPRSNID>SANDRA M. </SLPRSNID>
<UPSZONE> </UPSZONE>
<BACHNUMB>INVOICES </BACHNUMB>
<PRBTADCD>PRIMARY </PRBTADCD>
<PRSTADCD>PRIMARY </PRSTADCD>
<PYMTRMID>Net 30 </PYMTRMID>
<ReqShipDate>1/23/2024 12:00:00 AM</ReqShipDate>
<UpdateExisting>1</UpdateExisting>
<PRCLEVEL>RETAIL </PRCLEVEL>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true"/>
<taSopUpdateCreateProcessHold xsi:nil="true"/>
<taCreateSOPTrackingInfo xsi:nil="true"/>
<taMdaUpdate_Items xsi:nil="true"/>
</SOPTransactionType>
</eConnect>