Also getting errors: 795 Stored Procedure= taSopLineIvcTaxInsert Error Description = Tax detail already exists Have tried all the online suggestions keep bouncing between these 2 errors. I have tried both XML and CSV
<?xml version="1.0"?>
<eConnect>
<SOPTransactionType>
<eConnectProcessInfo>
<ConnectionString>data source=gpsql;initial catalog=TUSBC;integrated security=SSPI;persist security info=False;packet size=4096;Connect Timeout=10</ConnectionString>
</eConnectProcessInfo>
<taSopLineIvcInsert>
<PHONE2> </PHONE2>
<STATE>TX</STATE>
<ITEMDESC>The Core Kit</ITEMDESC>
<ShipToName>Terry Richards</ShipToName>
<PHONE1>2142223333</PHONE1>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<ZIPCODE>75422</ZIPCODE>
<ADDRESS1>100 Main Street</ADDRESS1>
<CITY>Dallas</CITY>
<SOPTYPE>3</SOPTYPE>
<ADDRESS2> </ADDRESS2>
<UOFM>EA</UOFM>
<ITEMNMBR>TC0001</ITEMNMBR>
<UpdateIfExists>0</UpdateIfExists>
<QUANTITY>1</QUANTITY>
<DOCDATE>2016-9-22</DOCDATE>
<CURNCYID>Z-US$</CURNCYID>
<DOCID>TCINV</DOCID>
<UNITPRCE>134.99</UNITPRCE>
<XTNDPRCE>134.99</XTNDPRCE>
<LOCNCODE>USBC01</LOCNCODE>
<COUNTRY>US</COUNTRY>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<TAXAMNT>10.8</TAXAMNT>
<TAXSCHID>TEXAS</TAXSCHID>
<LNITMSEQ>1</LNITMSEQ>
</taSopLineIvcInsert>
<taSopLineIvcTaxInsert_Items>
<taSopLineIvcTaxInsert>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<LNITMSEQ>1</LNITMSEQ>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<STAXAMNT>10.8</STAXAMNT>
<SALESAMT>145.79</SALESAMT>
<TAXDTLID>TEXAS</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
</taSopLineIvcTaxInsert>
<taSopLineIvcTaxInsert>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<LNITMSEQ>1</LNITMSEQ>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<STAXAMNT>10.8</STAXAMNT>
<SALESAMT>145.79</SALESAMT>
<TAXDTLID>TEXAS</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
</taSopLineIvcTaxInsert>
<taSopLineIvcTaxInsert>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<LNITMSEQ>1</LNITMSEQ>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<STAXAMNT>10.8</STAXAMNT>
<SALESAMT>145.79</SALESAMT>
<TAXDTLID>TEXAS</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
</taSopLineIvcTaxInsert>
</taSopLineIvcTaxInsert_Items>
<taCreateSopPaymentInsertRecord>
<DOCAMNT>145.79</DOCAMNT>
<PYMTTYPE>6</PYMTTYPE>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<CUSTNAME>Terry Richards</CUSTNAME>
<CARDNAME>VISA</CARDNAME>
<EXPNDATE>2017-12-1</EXPNDATE>
<SOPTYPE>3</SOPTYPE>
<RCTNCCRD>4242</RCTNCCRD>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<AUTHCODE>ch_18sw7AE1245jPojbHADCWMWL</AUTHCODE>
<DOCDATE>2016-9-22</DOCDATE>
<DOCNUMBR>0000027</DOCNUMBR>
</taCreateSopPaymentInsertRecord>
<taSopDistribution>
<CRDTAMNT>134.99</CRDTAMNT>
<ACTINDX>3022</ACTINDX>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<SOPTYPE>3</SOPTYPE>
<DistRef>The Core Purchase</DistRef>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<DISTTYPE>1</DISTTYPE>
<DEBITAMT> </DEBITAMT>
</taSopDistribution>
<taSopHdrIvcInsert>
<SOPNUMBE>TC160912101251717</SOPNUMBE>
<CUSTNAME>Terry Richards</CUSTNAME>
<ReqShipDate>2016-9-22</ReqShipDate>
<DOCAMNT>145.79</DOCAMNT>
<LOCNCODE>USBC01</LOCNCODE>
<CITY>Dallas</CITY>
<PHNUMBR2> </PHNUMBR2>
<PRSTADCD>SHIPPING</PRSTADCD>
<PRBTADCD>BILLING</PRBTADCD>
<DOCID>TCINV</DOCID>
<ADDRESS2> </ADDRESS2>
<DOCDATE>2016-9-22</DOCDATE>
<COUNTRY>US</COUNTRY>
<REFRENCE>The Core Purchase</REFRENCE>
<CUSTNMBR>TR2016I12J12517</CUSTNMBR>
<BACHNUMB>TC2016092</BACHNUMB>
<UpdateExisting>0</UpdateExisting>
<ShipToName>Terry Richards</ShipToName>
<ADDRESS1>100 Main Street</ADDRESS1>
<PYMTRMID>NET00</PYMTRMID>
<ZIPCODE>75422</ZIPCODE>
<PHNUMBR1>2142223333</PHNUMBR1>
<INVODATE>2016-9-22</INVODATE>
<PYMTRCVD>145.79</PYMTRCVD>
<BatchCHEKBKID>GFFROST</BatchCHEKBKID>
<CURNCYID>Z-US$</CURNCYID>
<SOPTYPE>3</SOPTYPE>
<STATE>TX</STATE>
<TAXSCHID>TEXAS - SALES</TAXSCHID>
<FRTTXAMT>0.00</FRTTXAMT>
<MISCAMNT>0.00</MISCAMNT>
<MISCTBLE>3</MISCTBLE>
<MSCTXAMT>0.00</MSCTXAMT>
<FREIGTBLE>3</FREIGTBLE>
<FREIGHT>0.00</FREIGHT>
<DEFTAXSCHDS>0</DEFTAXSCHDS>
<TAXAMNT>10.8</TAXAMNT>
<SUBTOTAL>134.99</SUBTOTAL>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>