questteam 2/2/2018 5:31:24 PM

Kit Order Fulfillment through econnect

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

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