Walmart decided to take over 100% of sales tax responsibility for the WA, MN, CT, IA, OK, PA, SD, NJ, AL, DC, NE, SC, NY, ID, AR, IN, KY, NM, ND, RI, VA, VT, WV, WY, OH, AZ, CA, CO, ME, MD, MA, NV, TX, UT, HI, WI, IL, MI, NC, and GA states (including filing and remittance). Based on applicable tax laws, Walmart now calculates, collects, and remits sales tax for orders shipped to customers in these states. In case you are shipping an order to these states, the requirement is for you to be able to import the same order in NetSuite with 0 sales tax.
To understand more about the Sales Tax collection in Walmart, refer here.
Workaround for the order flows
You can overwrite the tax calculation logic by configuring mappings for the Order flow. After you configure the below mappings and run the “Walmart Order to NetSuite Order Add” flow, the order is imported with 0 sales tax.
Important: The below handlebar expressions are for selective states. Configure the handlebar expressions as per your required state.
- Login to your integrator.io account.
- Click Walmart - NetSuite Integration App tile.
- Go to Integration Flows > Order > Walmart Order to NetSuite Order Add.
- Click on the Field Mappings icon next to the flow. The Mappings window is displayed.
- Based on your tax setup in your NetSuite account, such as line-level or body level taxes, add new mappings.
Export Field (HTTP) Import Field (NetSuite) Body Level taxes {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}F{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} istaxable {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} taxrate Line Level Taxes {{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}} item[*].taxrate1 {{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}} item[*].taxAmount {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} shippingtax1rate - Click Save & Close.
Tip: To see the imported taxes on the sales order, go to Sales Order > Etail tab > ETAIL TAX TOTAL VARIANCE.
Identifying tax setup in NetSuite
To verify your tax setup in your NetSuite account:
- Login to your NetSuite account.
- Go to Setup > Accounting > Set Up Taxes.
- On the Set Up Taxes page:
- If the “per-line taxes on transactions” box is selected, the taxes are applicable at the line level.
- If the “per-line taxes on transactions” box is unchecked, the taxes are applicable at the body level.
Comments
6 comments
I tried adding these handlebars but am getting an error when running the flow that the expression is incorrect.
Hello David Eisen
Can we please get more details on the issue. What is the tax setup you are using? Are you using Line level Taxes or Body Level Taxes? Can you also please provide the error you are getting in the flow run.
Sure,
We're using body level taxes, here's the error:
"Failed to add Walmart Order# 2815784269456. Could not compile handle bar \"{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' ‘KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (u...
Hi Khaisar,
Have you had a chance to look into this error?
Hello David Eisen
Sorry for the delay. Yes, I tried debugging this further and able to find the issue. If you observe the below screenshot, for the state code KS, it is opened with an incorrect symbol. It has to be a single quote. I have pasted the updated handlebar below for both the mentioned mappings,
For "istaxable" field mapping
For "taxrate" mapping
Please review this and let us know if you are still facing the issue.
Your fix is working well,
Thank you!
Please sign in to leave a comment.