Happy Business Starts Here

Highlighted
Zuora Support Moderator

Known Issue caused by a 3rd party - Invoice Tax Items mismatch in Zuora & Avalara

We came across this Invoice where the Tax posted on the Invoice in Zuora was reflected as below:
County: 2.25% on 1600 = $36
City: 0.5% on 1600 = $8
State: 2.75 % on 399 = $10.97

However, in Avalara it is reflected as following.
County: 2.25% on 1600 = $36
City: 0.5% on 1600 = $8
State: 7% on 1999 = $139.93
State: 2.75 % on 399 = $10.97

Why is it missing the state tax for 7% on 1999? 

 

Three tax items are on Zuora end. 

Screen Shot 2019-04-12 at 5.25.20 PM.png

Four tax items are on Avalara end. 

Screen_Shot_2019-04-12_at_5_25_50_PM.png

Regards,
Yong Xiang | yxiang@zuora.com
Application Support Engineer | Zuora Inc.



SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Support Moderator

Re: Known Issue caused by a 3rd party - Invoice Tax Items mismatch in Zuora & Avalara

Root cause

It is a known issue caused by 3rd party Avalara (tracking number 15764793, scheduled to be fixed in the first half of 2019). Avalara is not sending Zuora all the tax line items. The issue is resulting in small differences between tax reporting available in Zuora and AvaTax calculations. These small differences result from the display of incomplete tax details for a limited number of state-level jurisdictions—like Tennessee—where there are multiple components to the state-level tax. While the breakout of taxes by jurisdiction may be incorrect, the total tax calculated for invoicing, and the tax detail amounts recorded by Avalara and displayed in the AvaTax UI are correct.

 

The issue on the Avalara side is with Avalara batch(async) API call, and not with the real-time(sync) API call. So the issue might happen when a batch call response is sent by Avalara. For real-time UI and API call, it works fine.

 

Workaround

For the affected customer accounts, such as the state is Tennessee, post the draft invoice in UI manually or with below API call. You can also un-post the invoice and then post it again via UI or API. Please note this workaround only applies when the invoice item number of a specific invoice does not exceed 3,000.

 

REST call - https://rest.zuora.com/v1/object/invoice/{id}
Reference: https://www.zuora.com/developer/api-reference/#operation/Object_PUTInvoice

 

SOAP call - update() Invoice
Reference: https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Invoice

Regards,
Yong Xiang | yxiang@zuora.com
Application Support Engineer | Zuora Inc.



SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √