Hi, i trying to fulfill a kit through ecconect. I am fulfilling the line item as well as components . But it throws below error message
Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:
Error Number = 7220 Stored Procedure= taSopMultiBin Error Description = Bins for the item have already been assigned for the qty fulfilled on the line
Node Identifier Parameters: taSopMultiBin
SOPNUMBE = ORD00000094243
SOPTYPE = 2
ITEMNMBR = TRJ609E
LNITMSEQ = 16384
CMPNTSEQ = 16384
BIN = 3-P-25-B
<taSopMultiBin>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>TRJ609E</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<CMPNTSEQ>16384</CMPNTSEQ>
<BIN>3-P-25-B</BIN>
<QUANTITY>1</QUANTITY>
<OverrideBin>1</OverrideBin>
</taSopMultiBin>
---> Microsoft.Dynamics.GP.eConnect.eConnectException: Error Number = 7220 Stored Procedure taSopMultiBin Error Description = Bins for the item have already been assigned for the qty fulfilled on the line.
I have set the lineitem(taSopLineIvcInsert.QTYFULFI = 1 ) & Line components (taSopLineIvcInsertComponent.QTYFULFI =1 ). When I try to remove line fulfillment it still throws error. I dont understand what is wrong. Can you please help.
Below is the xml structure :
<?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 xsi:nil="true" />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<CUSTNMBR>SNOWJ01</CUSTNMBR>
<DOCDATE>2018-02-02</DOCDATE>
<LOCNCODE>NJ_305VET</LOCNCODE>
<ITEMNMBR>M43896</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>20.55000</UNITPRCE>
<XTNDPRCE>20.5500000000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMENT_1>ECOFPRI1</COMMENT_1>
<PRCLEVEL>QVCI01</PRCLEVEL>
<ITEMDESC>QVC KIT - 1 TRJ609E / 2 TRJ609ERS</ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>STD</DOCID>
<ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
<CITY>CARLSTADT</CITY>
<STATE>NJ</STATE>
<ZIPCODE>07072</ZIPCODE>
<COUNTRY>United States of America</COUNTRY>
<ReqShipDate>Monday, January 1, 1900</ReqShipDate>
<FUFILDAT>Friday, February 2, 2018</FUFILDAT>
<ACTLSHIP>Monday, January 1, 1900</ACTLSHIP>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>EACH</UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items>
<taSopLineIvcInsertComponent>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<LOCNCODE>NJ_305VET</LOCNCODE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>TRJ609E</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<QUANTITY>1</QUANTITY>
<CUSTNMBR>SNOWJ01</CUSTNMBR>
<DOCID>STD</DOCID>
<CMPNTSEQ>16384</CMPNTSEQ>
<UpdateIfExists>1</UpdateIfExists>
</taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<LOCNCODE>NJ_305VET</LOCNCODE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>TRJ609ERS</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<QUANTITY>2</QUANTITY>
<CUSTNMBR>SNOWJ01</CUSTNMBR>
<DOCID>STD</DOCID>
<CMPNTSEQ>32768</CMPNTSEQ>
<UpdateIfExists>1</UpdateIfExists>
</taSopLineIvcInsertComponent>
</taSopLineIvcInsertComponent_Items>
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<USRTAB09>jostr</USRTAB09>
</taSopUserDefined>
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items>
<taSopMultiBin>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>TRJ609E</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<CMPNTSEQ>16384</CMPNTSEQ>
<BIN>3-P-25-B</BIN>
<QUANTITY>1</QUANTITY>
<OverrideBin>1</OverrideBin>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>TRJ609ERS</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<CMPNTSEQ>32768</CMPNTSEQ>
<BIN>3-J-43-A</BIN>
<QUANTITY>2</QUANTITY>
<OverrideBin>1</OverrideBin>
</taSopMultiBin>
</taSopMultiBin_Items>
<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>STD</DOCID>
<SOPNUMBE>ORD00000094243</SOPNUMBE>
<SHIPMTHD>PPD_GROUND_RES</SHIPMTHD>
<DOCDATE>2018-02-02</DOCDATE>
<TRDISAMT>0.00000</TRDISAMT>
<CUSTNMBR>SNOWJ01</CUSTNMBR>
<CUSTNAME>SnowJoe.com - DS PPD</CUSTNAME>
<CSTPONBR>ECOFPRI1</CSTPONBR>
<ShipToName>SnowJoe.com - (DS PPD)</ShipToName>
<ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
<CITY>CARLSTADT</CITY>
<STATE>NJ</STATE>
<ZIPCODE>07072</ZIPCODE>
<COUNTRY>United States of America</COUNTRY>
<SUBTOTAL>20.55000</SUBTOTAL>
<DOCAMNT>20.55000</DOCAMNT>
<SLPRSNID>E_SJ</SLPRSNID>
<USER2ENT>test1</USER2ENT>
<BACHNUMB>EDIBATCH</BACHNUMB>
<PRBTADCD>MAIN</PRBTADCD>
<MSTRNUMB>1189724</MSTRNUMB>
<PYMTRMID>COD</PYMTRMID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
<DYSTINCR>0</DYSTINCR>
<RTCLCMTD>0</RTCLCMTD>
<FREIGTBLE>1</FREIGTBLE>
<MISCTBLE>1</MISCTBLE>
<UpdateExisting>1</UpdateExisting>
<PRCLEVEL>CASH01</PRCLEVEL>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>
Thanks
Priya