DynDeveloper.com

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

Have emails that are going to Draft folder in Outlook and show error on email report, these used to go without a problem.  I doubled checked the email address, which is correct, made sure it the email was on the right line on the Vendor maintenance card, made sure they had EFT in the Remit To on the maintenance card and on the voucher.  She is using a word template for the EFT Remittance.  Anyone have any ideas what would be causing some to email and others not to?

We are using Great Plains 2016R2 version 16.00.0579(R2) and Microsoft Office 365 Outlook

Sandy

Good morning,

   I system show me this message "This document has been removed from sales orders processing history" when i go to Inquiry/Sales/Transaction by Customer after redisplay and show me a invoice list and that fine but when click "Document number" to see the line items detail the above message appear.  I try in the Inquiry/Sales Documents or Sales Item option and work fine. Any suggestion is welcome.

Thanks,

Mr. García

Note:  I have GP2016

I am trying to understand what I need to do here. I am migrating an VST application that uses a lot of listviews from GP2015 to work with GP2018 web client. I understand that the listview is not supported, however, the only documentation I can find specifies a Silverlight form in it's place. But GP2018 is HTML based? So does anyone know the answer to this? Do I still need to develop a Silverlight form?

Many thanks in advance

I have a kit item M43896 which contains two components items TRJ609E & TRJ609ERS. I am trying to fulfill the KIT through econnect. Please check the snapshot below. The component gets fulfilled but the main linetem is not fulfilled.

Attached is the zip file for xml sent to econnect.