DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

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

HI, Is there anyway to make VST forms toolbar look like the new Action Pane with the larger buttons and icons?

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

Hi, 

I need to prove that the PM distributions created are actually posted in the GL tables. How do I connect the dots between the two? I can make a lovely list of distributions from PM10100 and PM30600, but how do I prove that any one entry is posted in the GL20000 or GL30000 tables? I don't know where to find a database scheme to tell me how to link the two tables... Help!?

Kristie Lundberg

klundberg@themine.com

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

Hi,

When generating an EFT file, I get this error: "The Transaction File has been generated with 0 transactions and is in the following location:  Review the file and transmit to your financial institution to complete the transfer."

Does anyone know what is causing this? And more importantly, how to resolve it? There is one transaction in the batch.

Thanks

Paul

In the Web Services, it seems the only time when a payment can be included with a payableinvoice is at its creation.  There's no method where you can use a reference like the voucher number and apply a payment explicitly to it.  The main goal here for me, is to pull up unpaid vouchers and apply a check against them, in date order, until the money runs out, likely resulting in partial payment of one of them.

We have three batches of recurring sales orders that are run each month.   We need to remove a few of the orders from the batches, due to these customers being inactive now and no longer getting these recurring orders. 

I have not found how to do that in GP.