Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

Posted on by 180

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

  • PavanBujji Profile Picture
    PavanBujji 180 on at
    RE: How does Avatax Tax (AVALARA) work in Dynamics GP ?.

    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.

  • PavanBujji Profile Picture
    PavanBujji 180 on at
    RE: How does Avatax Tax (AVALARA) work in Dynamics GP ?.

    Thanks for responding Praveen.

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

    Thank you,

    Pavan .

  • Verified answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: How does Avatax Tax (AVALARA) work in Dynamics GP ?.

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans