DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 
Today a client asked if we could create a mod that allowed a user to view a PDF (or any document) where the name of the file is stored in a notes field. In our example we're using the PM Transaction Entry form, but any form will do. 
Sql procedure error codes returned:
Error Number = 3640  Stored Procedure= taCreateSopPaymentInsertRecord  Error Description = Invalid Payment Type (4=Cash Payment, 5=Check Payment, 6=Credit Card Payment)
Node Identifier Parameters: taCreateSopPaymentInsertRecord
SOPNUMBE = RTN-#1-1002-1       
SOPTYPE = 4
PYMTTYPE = 3
Related Error Code Parameters for Node : taCreateSopPaymentInsertRecord
PYMTTYPE = 3

 

<taCreateSopPaymentInsertRecord>
  <SOPTYPE>4</SOPTYPE>
  <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
  <CUSTNMBR>SR99999        </CUSTNMBR>
  <DOCDATE>2/11/2018</DOCDATE>
  <DOCAMNT>10.00000</DOCAMNT>
  <CARDNAME>WEBSITE        </CARDNAME>
  <PYMTTYPE>3</PYMTTYPE>
  <USRDEFND1>REFUND                                            </USRDEFND1>
</taCreateSopPaymentInsertRecord>

 

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <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>4</SOPTYPE>
        <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
        <CUSTNMBR>SR99999        </CUSTNMBR>
        <DOCDATE>2/11/2018</DOCDATE>
        <LOCNCODE>51        </LOCNCODE>
        <ITEMNMBR>GC10                          </ITEMNMBR>
        <AutoAssignBin>0</AutoAssignBin>
        <UNITPRCE>10.00000</UNITPRCE>
        <XTNDPRCE>10.00000</XTNDPRCE>
        <QUANTITY>1.00000</QUANTITY>
        <QTYONHND>1.00000</QTYONHND>
        <NONINVEN>1</NONINVEN>
        <LNITMSEQ>16384</LNITMSEQ>
        <INTEGRATIONID>16384                         </INTEGRATIONID>
        <UOFM>Each    </UOFM>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
    <taSopLineIvcInsertComponent_Items xsi:nil="true" />
    <taSopTrackingNum_Items xsi:nil="true" />
    <taSopCommissions_Items xsi:nil="true" />
    <taSopLineIvcTaxInsert_Items xsi:nil="true" />
    <taCreateSopPaymentInsertRecord_Items>
      <taCreateSopPaymentInsertRecord>
        <SOPTYPE>4</SOPTYPE>
        <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
        <CUSTNMBR>SR99999        </CUSTNMBR>
        <DOCDATE>2/11/2018</DOCDATE>
        <DOCAMNT>10.00000</DOCAMNT>
        <CARDNAME>WEBSITE        </CARDNAME>
        <PYMTTYPE>3</PYMTTYPE>
        <USRDEFND1>REFUND                                            </USRDEFND1>
      </taCreateSopPaymentInsertRecord>
    </taCreateSopPaymentInsertRecord_Items>
    <taSopUserDefined xsi:nil="true" />
    <taSopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taSopMultiBin_Items xsi:nil="true" />
    <taSopHdrIvcInsert>
      <SOPTYPE>4</SOPTYPE>
      <DOCID>RETURN         </DOCID>
      <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
      <TAXSCHID>EXEMPT         </TAXSCHID>
      <SHIPMTHD>C GROUND       </SHIPMTHD>
      <LOCNCODE>51        </LOCNCODE>
      <DOCDATE>2/11/2018</DOCDATE>
      <CUSTNMBR>SR99999        </CUSTNMBR>
      <CSTPONBR>AUTHORIZE_NET       </CSTPONBR>
      <ShipToName>Steel</ShipToName>
      <ADDRESS1>651 Main</ADDRESS1>
      <ADDRESS2>Suite 105                                                   </ADDRESS2>
      <CITY>Bowling Green                      </CITY>
      <STATE>KY                           </STATE>
      <ZIPCODE>42101     </ZIPCODE>
      <COUNTRY>US                                                          </COUNTRY>
      <SUBTOTAL>10.00000</SUBTOTAL>
      <DOCAMNT>10.00000</DOCAMNT>
      <PYMTRCVD>10.00000</PYMTRCVD>
      <BACHNUMB>SHIPPED        </BACHNUMB>
      <PYMTRMID>credit card         </PYMTRMID>
      <USRDEFND1>SMTST                                             </USRDEFND1>
    </taSopHdrIvcInsert>
    <taSopToPopLink xsi:nil="true" />
    <taSopUpdateCreateProcessHold xsi:nil="true" />
    <taCreateSOPTrackingInfo xsi:nil="true" />
    <taMdaUpdate_Items xsi:nil="true" />
  </SOPTransactionType>
</eConnect>
Sql procedure error codes returned:
Error Number = 60  Stored Procedure= taSopHdrIvcInsert  Error Description = Payment total does not match line deposit + credit card payment total
Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = RTN-#1-1002-1       
SOPTYPE = 4
Related Error Code Parameters for Node : taSopHdrIvcInsert
PYMTRCVD = 10.00000
<taSopHdrIvcInsert>
  <SOPTYPE>4</SOPTYPE>
  <DOCID>RETURN         </DOCID>
  <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
  <TAXSCHID>EXEMPT         </TAXSCHID>
  <SHIPMTHD>C GROUND       </SHIPMTHD>
  <LOCNCODE>51        </LOCNCODE>
  <DOCDATE>2/11/2018</DOCDATE>
  <CUSTNMBR>SR99999        </CUSTNMBR>
  <CSTPONBR>#1-1002             </CSTPONBR>
  <ShipToName>Steel Mill &amp; Co                                                 </ShipToName>
  <ADDRESS1>651 US 31 Bypass                                            </ADDRESS1>
  <ADDRESS2>Suite 105                                                   </ADDRESS2>
  <CITY>Bowling Green                      </CITY>
  <STATE>KY                           </STATE>
  <ZIPCODE>42101     </ZIPCODE>
  <COUNTRY>US                                                          </COUNTRY>
  <SUBTOTAL>10.00000</SUBTOTAL>
  <DOCAMNT>10.00000</DOCAMNT>
  <PYMTRCVD>10.00000</PYMTRCVD>
  <BACHNUMB>SHIPPED        </BACHNUMB>
  <PYMTRMID>credit card         </PYMTRMID>
  <USRDEFND1>SMTST                                             </USRDEFND1>
</taSopHdrIvcInsert>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <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>4</SOPTYPE>
        <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
        <CUSTNMBR>SR99999        </CUSTNMBR>
        <DOCDATE>2/11/2018</DOCDATE>
        <LOCNCODE>51        </LOCNCODE>
        <ITEMNMBR>GC                            </ITEMNMBR>
        <AutoAssignBin>0</AutoAssignBin>
        <UNITPRCE>10.00000</UNITPRCE>
        <XTNDPRCE>10.00000</XTNDPRCE>
        <QUANTITY>1.00000</QUANTITY>
        <QTYONHND>1.00000</QTYONHND>
        <LNITMSEQ>16384</LNITMSEQ>
        <INTEGRATIONID>16384                         </INTEGRATIONID>
        <UOFM>Each    </UOFM>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
    <taSopLineIvcInsertComponent_Items xsi:nil="true" />
    <taSopTrackingNum_Items xsi:nil="true" />
    <taSopCommissions_Items xsi:nil="true" />
    <taSopLineIvcTaxInsert_Items xsi:nil="true" />
    <taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
    <taSopUserDefined xsi:nil="true" />
    <taSopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taSopMultiBin_Items xsi:nil="true" />
    <taSopHdrIvcInsert>
      <SOPTYPE>4</SOPTYPE>
      <DOCID>RETURN         </DOCID>
      <SOPNUMBE>RTN-#1-1002-1        </SOPNUMBE>
      <TAXSCHID>EXEMPT         </TAXSCHID>
      <SHIPMTHD>C GROUND       </SHIPMTHD>
      <LOCNCODE>51        </LOCNCODE>
      <DOCDATE>2/11/2018</DOCDATE>
      <CUSTNMBR>SR99999        </CUSTNMBR>
      <CSTPONBR>#1-1002             </CSTPONBR>
      <ShipToName>Steel </ShipToName>
      <ADDRESS1>651 Main  </ADDRESS1>
      <ADDRESS2>Suite 105                                                   </ADDRESS2>
      <CITY>Bowling Green                      </CITY>
      <STATE>KY                           </STATE>
      <ZIPCODE>42101     </ZIPCODE>
      <COUNTRY>US                                                          </COUNTRY>
      <SUBTOTAL>10.00000</SUBTOTAL>
      <DOCAMNT>10.00000</DOCAMNT>
      <PYMTRCVD>10.00000</PYMTRCVD>
      <BACHNUMB>SHIPPED        </BACHNUMB>
      <PYMTRMID>credit card         </PYMTRMID>
      <USRDEFND1>SMTST                                             </USRDEFND1>
    </taSopHdrIvcInsert>
    <taSopToPopLink xsi:nil="true" />
    <taSopUpdateCreateProcessHold xsi:nil="true" />
    <taCreateSOPTrackingInfo xsi:nil="true" />
    <taMdaUpdate_Items xsi:nil="true" />
  </SOPTransactionType>
</eConnect>

A user on the GPUG forum just asked "I'm trying to create a SmartList that shows number of invoices paid per month and if they were paid late"

Please note that there is a difference between the day the payment is received, and the date of the apply. In this view, I'm using the date that the payment was received.

That sounded like a good blog, so here it is...

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.   

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 am looking for a table in GP payables that stores the descriptions for 1099 box. Here are the values I am getting from the GP dropdown list.

1 - Rent

2 - Royalties

3 - Other Income

4 - Federal Income Tax Withheld

5 - Fishing Boat Proceeds

6 - Medical and Health Care Payments

7 - Nonemployee Compensation

8 - Payments in Lieu of Dividends/Interest

10 – Crop Insurance Proceeds

13 – Excess Golden Parachute Payments

14 – Gross Proceeds Paid to an Attorney

15a – Section 409A Deferrals

15b – Section 409A Income

 

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.

<?xml version="1.0" encoding="UTF-8"?>
   <SOPTransactionType>
      <taSopLineIvcInsert_Items>
         <taSopLineIvcInsert>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>EDI0001254080</SOPNUMBE>
            <CUSTNMBR>SNOWJ01</CUSTNMBR>
            <DOCDATE>2018-02-27</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>ZXC</COMMENT_1>
            <PRCLEVEL>QVCI01</PRCLEVEL>
            <ITEMDESC>QVC KIT - 1 TRJ609E / 2 TRJ609ERS</ITEMDESC>
            <LNITMSEQ>16384</LNITMSEQ>
            <ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
            <CITY>CARLSTADT</CITY>
            <STATE>NJ</STATE>
            <ZIPCODE>07072</ZIPCODE>
            <COUNTRY>United States of America</COUNTRY>
            <FUFILDAT>Tuesday, February 27, 2018</FUFILDAT>
            <UpdateIfExists>1</UpdateIfExists>
            <UOFM>EACH</UOFM>
         </taSopLineIvcInsert>
      </taSopLineIvcInsert_Items>
      <taSopLineIvcInsertComponent_Items>
         <taSopLineIvcInsertComponent>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>EDI0001254080</SOPNUMBE>
            <LOCNCODE>NJ_305VET</LOCNCODE>
            <LNITMSEQ>16384</LNITMSEQ>
            <ITEMNMBR>TRJ609E</ITEMNMBR>
            <AutoAssignBin>0</AutoAssignBin>
            <QUANTITY>1</QUANTITY>
            <CUSTNMBR>SNOWJ01</CUSTNMBR>
            <CMPNTSEQ>16384</CMPNTSEQ>
            <CMPITUOM>EACH</CMPITUOM>
            <UpdateIfExists>1</UpdateIfExists>
            <QtyShrtOpt>1</QtyShrtOpt>
         </taSopLineIvcInsertComponent>
         <taSopLineIvcInsertComponent>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>EDI0001254080</SOPNUMBE>
            <LOCNCODE>NJ_305VET</LOCNCODE>
            <LNITMSEQ>16384</LNITMSEQ>
            <ITEMNMBR>TRJ609ERS</ITEMNMBR>
            <AutoAssignBin>0</AutoAssignBin>
            <QUANTITY>2</QUANTITY>
            <CUSTNMBR>SNOWJ01</CUSTNMBR>
            <CMPNTSEQ>32768</CMPNTSEQ>
            <CMPITUOM>EACH</CMPITUOM>
            <UpdateIfExists>1</UpdateIfExists>
            <QtyShrtOpt>1</QtyShrtOpt>
         </taSopLineIvcInsertComponent>
      </taSopLineIvcInsertComponent_Items>
      <taSopUserDefined>
         <SOPTYPE>2</SOPTYPE>
         <SOPNUMBE>EDI0001254080</SOPNUMBE>
         <USRTAB09>jostr</USRTAB09>
      </taSopUserDefined>
      <taSopDistribution_Items xsi:nil="true" />
 
      <taSopMultiBin_Items>
         <taSopMultiBin>
            <SOPNUMBE>EDI0001254080</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>EDI0001254080</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>EDI</DOCID>
         <SOPNUMBE>EDI0001254080</SOPNUMBE>
         <SHIPMTHD>PPD_GROUND_RES</SHIPMTHD>
         <DOCDATE>2018-02-27</DOCDATE>
         <TRDISAMT>0.00000</TRDISAMT>
         <CUSTNMBR>SNOWJ01</CUSTNMBR>
         <CUSTNAME>SnowJoe.com - DS PPD</CUSTNAME>
         <CSTPONBR>ZXC</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>PICKED-DS</BACHNUMB>
         <PRBTADCD>MAIN</PRBTADCD>
         <MSTRNUMB>1259965</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>
   </SOPTransactionType>
</eConnect>