Problem integrating orders with sales tax 1

[rendlert07]

Hi everyone,

I have not been able to successfully integrate an order into GreatPlains (using eenterprise 7 and econnect7) when it has sales tax applied to it. Ive been successfully able to integrate 10s of 1000s of orders that didnt have sales tax.
------------------------------------------
The error i get is always the same:

Error Number = 62 Stored Procedure taSopHdrIvcInsert Error Description = Tax table detail does not equal the tax amount
----------------------------------------------
Here is an example of the XML being passed to econnect for an order with sales tax:

<eConnect xmlns:xsd="

http://www.w3.org/2001/XMLSchema"

xmlns:xsi="

http://www.w3.org/2001/XMLSchema-instance">

<SMCustomerMasterType>
<taUpdateCreateCustomerRcd>
<CUSTNMBR>BUY407826</CUSTNMBR>
<CUSTNAME>Gail Kaviani-Far</CUSTNAME>
<CUSTCLAS>BUYCOSTUMES</CUSTCLAS>
<ADDRESS1>3573 Bee Lane</ADDRESS1>
<CITY>Beloit</CITY>
<STATE>WI</STATE>
<PHNUMBR1>6083635124</PHNUMBR1>
<PRBTADCD>PRIMARY</PRBTADCD>
<PRSTADCD>PRIMARY</PRSTADCD>
<ADRSCODE>PRIMARY</ADRSCODE>
</taUpdateCreateCustomerRcd>
<taCreateCustomerAddress_Items>
<taCreateCustomerAddress>
<CUSTNMBR>BUY407826</CUSTNMBR>
<ADRSCODE>PRIMARY</ADRSCODE>
<ADDRESS1>3573 Bee Lane</ADDRESS1>
<COUNTRY>US</COUNTRY>
<CITY>Beloit</CITY>
<STATE>WI</STATE>
<ZIPCODE>53511</ZIPCODE>
<PHNUMBR1>6083635124</PHNUMBR1>
<USRDEFND1>BILLING</USRDEFND1>
</taCreateCustomerAddress>
</taCreateCustomerAddress_Items>
</SMCustomerMasterType>
<SOPTransactionType>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>927567</SOPNUMBE>
<CUSTNMBR>BUY407826</CUSTNMBR>
<CUSTNAME>Gail Kaviani-Far</CUSTNAME>
<ITMCLSCD>BUYCOSTUME</ITMCLSCD>
<DOCDATE>2005-02-09T00:00:00.0000000-06:00</DOCDATE>
<ITEMNMBR>113317</ITEMNMBR>
<UNITPRCE>31.99</UNITPRCE>
<XTNDPRCE>31.99</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<TAXAMNT>1.76</TAXAMNT>
<ShipToName>Gail Kaviani-Far</ShipToName>
<ADDRESS1>3573 Bee Lane</ADDRESS1>
<CITY>Beloit</CITY>
<STATE>WI</STATE>
<ZIPCODE>53511</ZIPCODE>
<COUNTRY>US</COUNTRY>
<SHIPMTHD>3</SHIPMTHD>
<USRDEFND1>801383</USRDEFND1>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcTaxInsert_Items>
<taSopLineIvcTaxInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>927567</SOPNUMBE>
<CUSTNMBR>BUY407826</CUSTNMBR>
<SALESAMT>31.99</SALESAMT>
<TAXDTLID>WI</TAXDTLID>
<STAXAMNT>1.76</STAXAMNT>
</taSopLineIvcTaxInsert>
</taSopLineIvcTaxInsert_Items>
<taCreateSopPaymentInsertRecord_Items>
<taCreateSopPaymentInsertRecord>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>927567</SOPNUMBE>
<CUSTNMBR>BUY407826</CUSTNMBR>
<DOCDATE>2005-02-09T00:00:00.0000000-06:00</DOCDATE>
<DOCAMNT>42.74</DOCAMNT>
<CARDNAME>Retail Credit</CARDNAME>
<EXPNDATE>1900-01-01T00:00:00.0000000-06:00</EXPNDATE>
<PYMTTYPE>6</PYMTTYPE>
</taCreateSopPaymentInsertRecord>
</taCreateSopPaymentInsertRecord_Items>
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>BUYCOSTUMES</DOCID>
<SOPNUMBE>927567</SOPNUMBE>
<TAXSCHID>WI</TAXSCHID>
<SHIPMTHD>3</SHIPMTHD>
<TAXAMNT>1.76</TAXAMNT>
<DOCDATE>2005-02-09T00:00:00.0000000-06:00</DOCDATE>
<FREIGHT>8.99</FREIGHT>
<CUSTNMBR>BUY407826</CUSTNMBR>
<CUSTNAME>Gail Kaviani-Far</CUSTNAME>
<ShipToName>Gail Kaviani-Far</ShipToName>
<ADDRESS1>3573 Bee Lane</ADDRESS1>
<CITY>Beloit</CITY>
<STATE>WI</STATE>
<ZIPCODE>53511</ZIPCODE>
<COUNTRY>US</COUNTRY>
<PHNUMBR1>6083635124</PHNUMBR1>
<SUBTOTAL>31.99</SUBTOTAL>
<DOCAMNT>42.74</DOCAMNT>
<PYMTRCVD>42.74</PYMTRCVD>
<SALSTERR>WEBSITE</SALSTERR>
<BACHNUMB>_BUYCOSTUMES</BACHNUMB>
<PRBTADCD>PRIMARY</PRBTADCD>
<PRSTADCD>PRIMARY</PRSTADCD>
<USRDEFND1>1079846720003232245096</USRDEFND1>
<USRDEFND2>469530</USRDEFND2>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>



Please please if anyone can share any insight into what i may be doing wrong or what i may be able to try in order to get this working i would be eternally grateful!

Thanks For Reading!

 

[Luvsql]

Typically, this error means that the total tax amount you import doesn't equal the amount that appears in the tax detail window. Does the order integrate with warnings or does it completely not integrate at all? I don't see the link between the SOPTaxWorkHist table, which stores the tax detail totals. Is this available to link as well (not familiar with econnect; only integration manager).

 

[rendlert07]

Unfortunately the orders dont integrate at all leaving a lot of manual entry to be done.

As for the SOPTaxWorkHist table, there are no other xml elements available for tax purposes that i am not already using.

 

[PCIEducation]

Are you still having problems with this issue? I had this same exact problem and I can prolly give you an idea of what to post to correct it.. I'm having problems right now with requesting a Customer Document. Can you help with that maybe?

 

[PCIEducation]

I'm getting an error on the Requester

Unique MessageId = Customer
Line Number=6440 Version=8.0.0.0
Error Source = Microsoft OLE DB Provider for SQL ServerError Number = -2147217887 Error Description = The statement has been terminated. Node Sequence Number = 1
Document Node: <eConnectOut><DOCTYPE>Customer</DOCTYPE>

My XML:

<?xml version="1.0" encoding="utf-8" ?><eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes"><RQeConnectOutType><eConnectProcessInfo><Outgoing>TRUE</Outgoing><MessageID>Customer</MessageID></eConnectProcessInfo><eConnectOut><DOCTYPE>Customer</DOCTYPE> <OUTPUTTYPE>2</OUTPUTTYPE><INDEX1TO>346710</INDEX1TO><INDEX1FROM>346710</INDEX1FROM><FORLOAD>0</FORLOAD><FORLIST>1</FORLIST><ACTION>0</ACTION><ROWCOUNT>0</ROWCOUNT><REMOVE>0</REMOVE></eConnectOut></RQeConnectOutType></eConnect>


I know the customer number exists.... what gives?

 

[VictoriaYudin]

I believe you need to populate the LNITMSEQ field to make this error go away. There is an example of this in the 1051 SOP INV2025H INV TAXES.xml sample document.

 

[PCIEducation]

Are you talking about the Customer Document Record error, or are you talking about the Taxes error from rendlert07?

 

[VictoriaYudin]

Sorry, I was replying to the original post about the taxes error.