I'm investigating a problem of mismatched Shopify and NetSuite taxes on orders. We've configured the Celigo Shopify integration app to overwrite NetSuite's per-line taxes - we want the order in NetSuite to use the Shopify tax amount. Here is a screen shot of the settings in use.
I read the documentation located here: https://docs.celigo.com/hc/en-us/articles/360003975112-Handling-order-sales-tax-in-NetSuite
The total tax is calculated for every item in an order and individual tax code and tax rate is displayed in every line as displayed in the following screen:
This sounds like exactly what I would expect it to do and looking at the screen shot in the documentation, it is calculating the effective tax rate based on what was charged in Shopify - perfect! But... this isn't happening in our integration for some reason.
Some additional points:
- On the orders that don't match, the eTail > eTail Tax Total Variance field is 0 (i.e. no variance).
- The sum of eTail Order Line Tax values equals the Shopify total tax amount
- To be clear: I'm not trying to make NetSuite's calculations match Shopify, I want to overwrite NetSuite's values with Shopify's values
I look forward to any details or insights anyone can provide. At this point it's difficult to investigate further not knowing what I should be expecting from the Celigo Shopify app.
Please sign in to leave a comment.