Hi guys, any Celigo experts out there that are familiar with how Celigo manipulates NS tax rates on import in the shopify > netsuite integration?

@aimpointmike have you checked out this doc? https://docs.celigo.com/hc/en-us/articles/360003975112-Manage-Shopify-order-sales-tax-in-NetSuite

hey Chris! I have. Im actually trying to recreate the black magic behind the scenes to match up refund transactions downstream from custom flows. when you configure this setting but are using say avalara in ns, it will create discrepancies in tax calc amounts on corresponding custom flows (for example a custom return flow outside the ns adapter ecosystem). So, I'm wondering if there is a slick way to piggy back Celigo's black magic to address directly in the flow vs scripted solution or leveraging the variance field and running topsides EOM

Hey Michael - if you send me an email to rico@celigo.com, I can direct this internally to someone who can answer that question for you.

Thanks buddy! Talk soon

@aimpointmike I had to deal with the same issue at my prior company and it's really just because NetSuite REALLY wants to recalculate everything. It required us to write the tax rate percentages to a custom field and then have a beforesubmit and/or aftersubmit script to override it after NetSuite performed its calculation.

Hey Tyler. Thanks for the feedback. Understood. I'm really trying to avoid UE's on the transactions which is why I was interested in what was happening behind the scenes in the Celigo connector scripts to default that rate from Shopify on import. If I cant get happy path, I will likely leverage this architecture or post variance to the provided or other custom field, build a search on top of that, and automate the topside creation with a manual rec review process to gate approval.

@aimpointmike everything we are doing behind the scenes utilizes UEs and RESTlets. You potentially could try using a suitescript hook that is called from the flow and we would run that hook within our own restlets as we import the record. https://docs.celigo.com/hc/en-us/articles/360050485392-SuiteScript-hooks-overview

Yep agreed.

What mappings do you have for tax right now? You could also try and map to taxrate field and see if that works.

Yep Im attempting that as well. Just trying to gather options as I go along. We are actually using a hb formula to calc the rate based on the net/tax amt data from the shop payload then injecting it into the tax rate field. Will let yall know if this works.

Let me know how it goes

Manually injecting the tax rate solves the issue