Hi All,
I want to know about AVATAX tax in dynamics GP.How does it calculate the tax in GP ?. Previously, We are using other Taxes . Now, we want to use AVATAX in GP.I have implemented the code through my connector code. econnect out XML is looking good.But tax is not calculating in GP.
I was roaming for this task from 2 days but i didn't get this done yet.
Below, I'm providing my Output xml which is sending to GP by using eConnct Classes.
<?xml version="1.0"?>
-<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
-<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true"/>
<taRequesterTrxDisabler_Items xsi:nil="true"/>
<taUpdateCreateItemRcd xsi:nil="true"/>
-<taUpdateCreateCustomerRcd>
<CUSTNMBR>50860012</CUSTNMBR>
<HOLD>0</HOLD>
<CUSTNAME>Pavan </CUSTNAME>
<SHRTNAME>Pavan </SHRTNAME>
<STMTNAME>Pavan </STMTNAME>
<CUSTCLAS>TAXABLE</CUSTCLAS>
<ADRSCODE>PRIMARY</ADRSCODE>
<TAXSCHID>AVATAX</TAXSCHID>
<PRBTADCD>PRIMARY</PRBTADCD>
</taUpdateCreateCustomerRcd>
-<taCreateCustomerAddress_Items>
-<taCreateCustomerAddress>
<CUSTNMBR>50860012</CUSTNMBR>
<ADRSCODE>PRIMARY</ADRSCODE>
<CNTCPRSN>Pavan Bujji</CNTCPRSN>
<ADDRESS1>Down Town Street</ADDRESS1>
<ADDRESS2/>
<CITY>New York</CITY>
<STATE>NY</STATE>
<ZIPCODE>10003</ZIPCODE>
<PHNUMBR1>9014521996</PHNUMBR1>
<FAX>0000000000</FAX>
<CCode>US</CCode>
<ShipToName>Pavan </ShipToName>
</taCreateCustomerAddress>
</taCreateCustomerAddress_Items>
<taSopSerial_Items xsi:nil="true"/>
<taSopLotAuto_Items xsi:nil="true"/>
-<taSopLineIvcInsert_Items>
-<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE/>
<CUSTNMBR>50860012</CUSTNMBR>
<DOCDATE>05/09/2019</DOCDATE>
<LOCNCODE>MAIN</LOCNCODE>
<ITEMNMBR>ATH</ITEMNMBR>
<UNITPRCE>2.50</UNITPRCE>
<QUANTITY>2.0000</QUANTITY>
<MRKDNAMT>0.25</MRKDNAMT>
<PRCLEVEL>RETAIL</PRCLEVEL>
<DOCID>MAGENTO</DOCID>
<SALSTERR>NC</SALSTERR>
<ITMTSHID>AVATAX</ITMTSHID>
<IVITMTXB>1</IVITMTXB>
<TAXSCHID>AVATAX</TAXSCHID>
<PRSTADCD>PRIMARY</PRSTADCD>
<SHIPMTHD>UPS GROUND</SHIPMTHD>
<DEFEXTPRICE>1</DEFEXTPRICE>
<UOFM>EA</UOFM>
<QtyShrtOpt>4</QtyShrtOpt>
</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>2</SOPTYPE>
<SOPNUMBE/>
<CUSTNMBR>50860012</CUSTNMBR>
<DOCAMNT>18.89</DOCAMNT>
<CARDNAME>VISA/MC</CARDNAME>
<RCTNCCRD>XXXXXXXXXXXX1111</RCTNCCRD>
<EXPNDATE>05/01/2022</EXPNDATE>
<PYMTTYPE>6</PYMTTYPE>
<Action>1</Action>
</taCreateSopPaymentInsertRecord>
</taCreateSopPaymentInsertRecord_Items>
-<taSopUserDefined>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE/>
<USRTAB01>n</USRTAB01>
<USRTAB03>CREDIT CARD</USRTAB03>
<USRDEF04>10342784</USRDEF04>
<USRDEF05>m8t40caz</USRDEF05>
</taSopUserDefined>
<taSopDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taSopMultiBin_Items xsi:nil="true"/>
-<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>MAGENTO</DOCID>
<TAXSCHID>AVATAX</TAXSCHID>
<SHIPMTHD>UPS GROUND</SHIPMTHD>
<LOCNCODE>MAIN</LOCNCODE>
<DOCDATE>05/09/2019</DOCDATE>
<FREIGHT>13.99</FREIGHT>
<CUSTNMBR>50860012</CUSTNMBR>
<PYMTRCVD>18.89</PYMTRCVD>
<BACHNUMB>ORD05092019</BACHNUMB>
<PRBTADCD>PRIMARY</PRBTADCD>
<PRSTADCD>PRIMARY</PRSTADCD>
<CREATECOMM>1</CREATECOMM>
<CREATETAXES>1</CREATETAXES>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<ReqShipDate>05/09/2019</ReqShipDate>
<CKHOLD>1</CKHOLD>
<PRCLEVEL>RETAIL</PRCLEVEL>
<DEFPRICING>1</DEFPRICING>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true"/>
<taSopUpdateCreateProcessHold xsi:nil="true"/>
<taCreateSOPTrackingInfo xsi:nil="true"/>
<taMdaUpdate_Items xsi:nil="true"/>
</SOPTransactionType>
</eConnect>
Could any one tell me where i'm missing here ?.
Thanks in advance.
Regards,
Pavan.
*This post is locked for comments