NetSuite populates the value in the PST rate field based on the tax code. As the PST tax rate in NetSuite is set by default, when you import order to NetSuite using any of the tax options from the “How would you like to bring sales tax into NetSuite” drop-down list, tax is calculated twice based on the tax rate provided by Amazon and based on the PST value provided by NetSuite. This leads to incorrect tax calculation. To handle this scenario, you have to manually overwrite the PST value in NetSuite by adding a new field mapping in the integration app.
Notes:
- The PST tax is applicable only for the Canada domain.
- This workaround is supported only with the integrator.io bundle v1.7.4.18 and later.
Prerequisite: Before your start, ensure that you install the latest Integratio.io bundle.
- From your Integrator.io account, click on the Amazon-NetSuite integration app tile.
- Go to Settings > Integration Flows > Order (FBA or MFN)
- Click on the Field Mappings icon, next to the “Amazon (FBA or MFN) Order to NetSuite Order” flow.
- On the Mappings window, set the “Use Address Subrecord” entry to “true” and add a new entry as shown in the table below:
- Note: If you are unable to find this field in the mappings drop-down list, refresh the metadata.
|
Export Field (HTTP) |
Import Field (NetSuite) |
|
“true” |
Use Address Subrecord |
|
“0” |
Items : PST Note: If you are unable to view the PST items after refreshing the metadata, replace Items : PST with item[*].<<NetSuitefieldinternalid>> in the field mapping, where <<NetSuitefieldinternalid>> is the field ID of the custom field assigned for PST items. |
- Click Save & Close.
- Run the “Amazon (FBA or MFN) Order to NetSuite Order” flow.
After you add this mapping in the integration app, when you import order to NetSuite, the PST tax value is overwritten as “0”, so that the tax is calculated by the tax rate provided by Amazon with the correct order amounts.
Example: The following table shows how the tax rates are calculated before and after you add the mapping:
|
Before Mapping |
After Mapping |
|
|
Sub Total |
9.99 |
9.99 |
|
GST/HST (5%) |
0.50 |
0.50 |
|
PST (7%) |
0.70 |
0.00 |
|
TOTAL |
11.19 |
10.49 |
Comments
5 comments
I think this article may need to be updated. I am not seeing Items: PST even after refreshing the metadata.
Hello Philip Dysert
Thank you for your comment. I'll get the article verified by the team and update it accordingly.
Philip Dysert Enter the field mapping in this format - Items : PST. If you are unable to view the PST items after refreshing the metadata, replace Items : PST with item[*].<<NetSuitefieldinternalid>> in the field mapping, where <<NetSuitefieldinternalid>> is the field ID of the custom field assigned for PST items. Let us know if this works for you.
In our situation we had to use item[*]taxrate2. I can confirm this is working now. Thank you
Philip Dysert That's great. Thank you for letting us know. We have added this information to the article as well.
Please sign in to leave a comment.