web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How does Avatax Tax (A...
Microsoft Dynamics GP (Archived)

How does Avatax Tax (AVALARA) work in Dynamics GP ?.

(0) ShareShare
ReportReport
Posted on by PavanBujji 208

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

I have the same question (0)
  • Verified answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,552 on at

    Hi Pavan,

    AVATAX will get calculated by passing value "AVATAX" for Tax Schedule ID field, but in your case, it seems that you are already passing it but still not getting calculated, so

    please try to setup Tax Schedule ID at ClassID level and map the customer with same ClassID.

    After setting up this ClassID with Tax Schedule, enter a SOP Transaction,

    Instead of Posting the transaction, try to print the invoice after saving it to a Batch ID,

    After Printing the Invoice, Navigate back the same Invoice you saved, where you should be able to see the Tax field in SOP Window with Calculated Value.

    If above steps doesn't solve your problem, please check the Server where GP and other Webservices installed, for its running status.

    Thanks,

    Praveen

  • PavanBujji Profile Picture
    PavanBujji 208 on at

    Thanks for responding Praveen.

    I will check it and update you once its working fine.

    Thank you,

    Pavan .

  • PavanBujji Profile Picture
    PavanBujji 208 on at

    Mr. Praveen ,

    I have another doubt in this regard.

    if we don't pass the Tax Amount along with AVALARA TAX ID . Can GP calculate the TAX amount for the order ?. or should we pass the Tax Amount ?.

    Thank You.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans