For those of you using Shopify w/ Avalara tax calc & Celigo, that tax is sometimes populated as a variance instead of total tax?

Hi Tim, sometimes, the order total in Shopify and NetSuite may not match—for example, if tax rates or other details differ between the two systems. To help track this, the Integration App automatically calculates any differences. If you feel as though there is a problem, please submit a Celigo Support ticket so we can dig into your settings/configurations.

@James Roth yes, and that is how it works normally. My issue is, sometimes an entire tax line is set as a variance. Netsuite will show 0 tax with a x.xx $ amount variance.

Tim, apologies for the delay. That is odd. I would recommend we get a support ticket submitted with an example. Perhaps an edgecase?

@James Roth it happens several times a day but seems to be more of a intermittent issue. I did create a case. They told me to delete a order and reimport but it wasn't feasible because it was a live production order. I tried to place several orders to recreate the issue and as it is intermittent I couldn't recreate so the ticket is dead in the water.