Dynamics Community Forum Thread Details

SOP Trx Data Integration using econnect : Sales Tax Error

At the time of integration using econnect, when i pass the TAXAMNT value in Sales Transaction Entry I receive following error :
Error : Tax Table Detail does not equal the tax amount(TAXAMNT).

I have passed two nodes,
1) <taSopHdrIvcInsert>
2) <taSopLineIvcInsert>

So,how to integrate Sales Transaction Entry for MS Dynamics GP version 2010?

<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE><DOCID>STDORD</DOCID><SOPNUMBE>ORDST2245</SOPNUMBE><TAXSCHID>USASTCITY-6*</TAXSCHID><SHIPMTHD>GROUND</SHIPMTHD><TAXAMNT>1</TAXAMNT><LOCNCODE>WAREHOUSE</LOCNCODE>
<DOCDATE>5/23/2017</DOCDATE><TRDISAMT>0</TRDISAMT><CUSTNMBR>CENTRALD0001</CUSTNMBR><CUSTNAME>Central Distributing</CUSTNAME><ShipToName>Central Distributing</ShipToName><ADDRESS1>727 25 St. N</ADDRESS1>
<CNTCPRSN>Jason Paul</CNTCPRSN><FAXNUMBR>0</FAXNUMBR><CITY>La Crosse</CITY><STATE>WI</STATE><ZIPCODE>54601-9975</ZIPCODE><COUNTRY>USA</COUNTRY><PHNUMBR1>6.09E+13</PHNUMBR1>
<PHNUMBR2>6.09E+13</PHNUMBR2><PHNUMBR3>0</PHNUMBR3><Print_Phone_NumberGB>0</Print_Phone_NumberGB><SUBTOTAL>12</SUBTOTAL><DOCAMNT>13</DOCAMNT><SALSTERR>TERRITORY 4</SALSTERR>
<SLPRSNID>SANDRA M.</SLPRSNID><USER2ENT>sa</USER2ENT><BACHNUMB>SOP ORDERS</BACHNUMB><PRBTADCD>PRIMARY</PRBTADCD><PRSTADCD>WAREHOUSE</PRSTADCD><ORDRDATE>5/23/2017</ORDRDATE>
<PYMTRMID>Net 30</PYMTRMID><BatchCHEKBKID>UPTOWN TRUST</BatchCHEKBKID><CREATEDIST>0</CREATEDIST><CURNCYID>Z-US$</CURNCYID><ReqShipDate>5/23/2017</ReqShipDate><PRCLEVEL>RETAIL</PRCLEVEL>
</taSopHdrIvcInsert>

<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE><SOPNUMBE>ORDST2245</SOPNUMBE><CUSTNMBR>CENTRALD0001</CUSTNMBR><DOCDATE>5/23/2017</DOCDATE><LOCNCODE>WAREHOUSE</LOCNCODE><ITEMNMBR>FAXX-SLK-2100</ITEMNMBR><UNITPRCE>12</UNITPRCE>
<XTNDPRCE>12</XTNDPRCE><QUANTITY>1</QUANTITY><PRCLEVEL>RETAIL</PRCLEVEL><ITEMDESC>Sleek UX-2100 fax</ITEMDESC><TAXAMNT>1</TAXAMNT><DOCID>STDORD</DOCID><SALSTERR>TERRITORY 4</SALSTERR>
<SLPRSNID>SANDRA M.</SLPRSNID><ITMTSHID>ALL DETAILS</ITMTSHID><IVITMTXB>1</IVITMTXB><TAXSCHID>USASTCITY-6*</TAXSCHID><PRSTADCD>WAREHOUSE</PRSTADCD><ShipToName>Central Distributing</ShipToName>
<CNTCPRSN>Jason Paul</CNTCPRSN><ADDRESS1>727 25 St. N</ADDRESS1><CITY>La Crosse</CITY><STATE>WI</STATE><ZIPCODE>54601-9975</ZIPCODE><COUNTRY>USA</COUNTRY><PHONE1>6.09E+13</PHONE1>
<PHONE2>6.09E+13</PHONE2><PHONE3>0</PHONE3><FAXNUMBR>0</FAXNUMBR><Print_Phone_NumberGB>0</Print_Phone_NumberGB><ReqShipDate>5/23/2017</ReqShipDate><FUFILDAT>4/23/2017</FUFILDAT>
<ACTLSHIP>5/23/2017</ACTLSHIP><SHIPMTHD>GROUND</SHIPMTHD><QTYFULFI>1</QTYFULFI>
</taSopLineIvcInsert>

Quick Links