Sync Amazon EU order tax codes to NetSuite invoice or sales order (custom flow template)

Contents

• Understand the flow
• Install and configure the template from the marketplace
  • Install the template
  • Configure the template
    • Step 1: Set up a connection to Amazon
    • Step 2: Set up a connection to NetSuite
    • Step 3: Install and verify the integrator.io bundle
    • Step 4: Copy resources from the template zip
• Download and configure the required script
  • Upload the file to your NetSuite account
  • Configure the script internal ID in the custom template flow
• Before you run the flow
  • Configure your NetSuite account
    • Create a custom transaction body field in NetSuite
    • Configure the saved search criteria
  • Configure mappings
    • Add the custom field mapping to the integration app flow
    • Add the custom field mapping to the template flow
• Configure settings
• Run the flow
• Understand the records in NetSuite

The integration app Amazon (FBA/MFN) Order to NetSuite Order Add flow is unable to manage the marketplace facilitator orders due to Amazon API limitations and syncs order taxes based on the ShipTo country. Because of this, incorrect tax codes are synced to the NetSuite invoice or sales order and lead to incorrect reporting and tax remittance. The Amazon EU order tax custom flow custom template syncs the Amazon EU order tax codes to NetSuite invoice or sales order based on the Jurisdiction or ShipTo country field (from the SC_VAT_TAX report). The SC_VAT_TAX report is a daily recurrent report. It is recommended to schedule this flow with "Once Daily" frequency, so that flow picks all the VAT information of the Orders that are fulfilled before three days.

Understand the flow

In the Amazon EU order tax details to NetSuite invoice or sales order flow, the Request Amazon “SC VAT Tax” report export requests for the SC VAT Tax report from Amazon. The flow-export gets the information related to the Buyer VAT Registration Id, Jurisdiction Name, Shipment Date, ShipFromCountry, and ShipToCountry details. The Update tax details to NetSuite invoice and Update tax details to NetSuite sales order imports look for the existing invoice or sales order that is already synced using the Amazon (FBA/MFN) Order to NetSuite Order Add flow of the Amazon - NetSuite integration app. The flow checks for the invoice. If the invoice is not found in NetSuite, the flow syncs the tax code to the sales order. If both invoice and sales order is not found, the flow ignores the order. It looks for these records in NetSuite based on the order ID in the eTail order ID field and syncs the data based on the below criteria:

• If an order is a marketplace facilitator tax order (Amazon collects the tax on behalf of the customer), and in the SC_VAT_TAX report, the value in the Tax Collection Responsibility column is “Marketplace,” the flow ignores the Amazon tax amounts and updates the tax amount to ‘0’ in NetSuite invoice or sales order. You can map the tax code in the Map ShipTo country code to marketplace facilitator order tax code setting and the flow updates the correct tax code based on jurisdiction name and custom tax codes created in NetSuite.
  
  Note: To manage and sync only marketplace facilitator orders by adding an export filter, contact Celigo Support.
• For order, if the EU One Stop Shop (OSS) feature check box is unchecked in your NetSuite account (Setup > Company > Enable Features), the flow updates the tax code in NetSuite based on the Buyer Tax Registration Jurisdiction value and the Map jurisdiction name to NetSuite tax code setting. 
• If the EU One Stop Shop (OSS) feature check box is checked in your NetSuite account (Setup > Company > Enable Features) and in the template Settings section: 
  • If the ShipTo and ShipFrom country are the same, use a country-specific tax code (the Amazon (FBA/MFN) Order to NetSuite Order Add flow already syncs this). The Amazon EU order tax details to NetSuite invoice or sales order don’t update the existing NetSuite order.
  • If ShipFrom and ShipTo countries are not the same, and ShipTo country is a home subsidiary, use a country-specific tax code for ShipTo country.
  • If ShipFrom and ShipTo countries are not the same, and ShipTo country is not a home subsidiary, use OSS specific tax for the ShipTo country.

Install and configure the template from the marketplace

Install the template

1. Login to your integrator.io account
2. On the left menu, click Marketplace.
3. Choose the appropriate integration, such as Amazon MWS or NetSuite. 
4. Search for Amazon EU order tax custom flow template.
   
5. Click Preview.
   
   
6. You can preview the components that are packaged as part of the template.
   
7. On the “Install template” window, click Install now.
   Tip: You can click View Readme to understand the feature documentation.
   
   
8. Read the Disclaimer, and accordingly click Proceed.
   
   
   You’ll be navigated to the template Flows page.

Configure the template

After you install the template, you’re navigated to the “Install Integration” page.

Step 1: Set up a connection to Amazon

Next to Step 1: Amazon connection, click Configure. To set up a connection with Amazon, refer here.

Step 2: Set up a connection to NetSuite

After successfully configuring the Amazon connection, next to Step 2: NetSuite connection, click Configure. To set up a connection to NetSuite, see Connect, configure, and integrate to NetSuite. 

Step 3: Install and verify the integrator.io bundle

1. Next to Step 3: integrator.io bundle, click Install.
   You’ll be navigated to the NetSuite page. 
2. ​​Log in to NetSuite using your NetSuite credentials.
3. On the “Install Integration” page, click Verify now.

Step 4: Copy resources from the template zip

Next to Step 4: Copy resources from the template zip, click Install.

After successfully installing the template, you’ll be navigated to the Flows page.

Download and configure the required script

Before you install the template, download the script file to your local drive.

Download

Note: Ensure that the file is downloaded in the .js format.

Upload the file to your NetSuite account

1. Log in to your NetSuite account with admin credentials.
2. In the global search bar, enter Page: File Cabinet. From the search results select the Page: File Cabinet option.
3. On the File Cabinet page, from the left-menu click SuiteScript. The Add File button will be enabled.
   
4. Click Add File and select the downloaded .js file from your local drive.
   
   
5. On the File Cabinet page, in the SuiteScripts section, next to the uploaded file, make a note of the internal ID.

Configure the script internal ID in the custom template flow

1. Log in to your integrator.io account.
2. Go to Flows.
3. Click on the Amazon EU order tax details to NetSuite invoice or sales order flow.
4. On the Flow Builder page, in the Update tax details to NetSuite invoice import bubble, click on the Hook icon.
   
   
5. On the Hooks window, in the Post map and Post Submit fields enter the values as follows:
   

   Post map
   Function	File internal ID
   amazonEUCustomImportPostMapHook	6398Note: The file internal ID mentioned here is just for reference. When you upload the file to NetSuite, the File internal ID will vary.
   Post submit
   Function	File internal ID
   amazonEUCustomImportPostSubmitHook	6398 Note: The file internal ID mentioned here is just for reference. When you upload the file to NetSuite, the File internal ID will vary.

   
6. Click Save & Close.
7. Repeat steps 4 to 6 for the Update tax details to NetSuite sales order import bubble.

Before you run the flow

After you run the Amazon (FBA/MFN) Order to NetSuite Order Add flow and sync the order and invoice records, it is recommended to run the billing flow NetSuite Order to NetSuite Invoice/Cash Sale flow after three days. 

Configure your NetSuite account

Create a custom transaction body field in NetSuite

1. Log in to your NetSuite account with admin credentials.
2. Go to Customization > List, Records, & Fields > Transaction Body Fields > New.
3. On the Transaction Body Field page, provide a valid Label and ID in the respective fields.
4. From the Type drop-down menu, select Check Box.
5. In the Applies To section, check the Sale check box.
6. Click Save.
   

Configure the saved search criteria

1. In the NetSuite global search, search for Celigo Amazon Auto Billing Export Search.
2. From the search results, select the appropriate saved search.
3. On the Celigo Amazon Auto Billing Export Search [<custom_name>]: Results page, click Edit this Search.
4. In the Criteria tab > Standard section, add a new row as follows:
   

   Filter	Description
   VAT/Tax code (Custom Body) Note: The name mentioned here is just an example, you can configure the name as per your business needs.	is true

5. Add the custom field mapping to the integration app flowSearch for the newly added transaction body field with the appropriate name.
   
   
6. On the Saved Transaction Search window, click Yes.
   
7. Click Set.
   
   
   
   
8. On the Celigo Amazon Auto Billing Export Search page, click Save.

Configure mappings

Add the custom field mapping to the integration app flow

Configure this mapping to ensure that the respective order record is not considered by the integration app flow.

1. Log in to your integrator.io account.
2. Go to Flows > Order (MFN).
3. Next to the Amazon (MFN) Order to NetSuite Order Add flow, click Mappings.
4. On the Edit Mapping: Amazon (MFN) Order Import Adaptor page, add the following mapping:
   

   Export field (Amazon Seller Central)	Import field (NetSuite)
   orderItem[*].rightTaxCode	Items : Tax Code (Internalid)

5. Click Save & close.

Add the custom field mapping to the template flow

1. Log in to your integrator.io account.
2. Go to Flows.
3. Next to the  Amazon EU order tax details to NetSuite invoice or sales order flow, click Mappings.
4. On the Edit Mapping window, click Update tax details to NetSuite sales order. 
5. On the Edit Mapping: Update tax details to NetSuite sales order page, add the following mapping:
   

   Export field (Amazon Seller Central)	Import field (NetSuite)
   orderItem[*].rightTaxCode	Items : Tax Code (Internalid)

6.  Click Save & close.

Configure settings

1. Go to Settings.
2. In the Home subsidiary country code field, enter a country code for your home subsidiary.
3. Check the EU One Stop Shop (OSS) box, if the EU One Stop Shop (OSS) feature check box is checked in your NetSuite account (Setup > Company > Enable Features).
4. In the Map ShipTo country code to marketplace facilitator order tax code setting, enter the ShipTo country code to map with the marketplace facilitator order tax code. This setting is applicable only for a marketplace facilitator order. The flow updates the marketplace facilitator order tax code on the NetSuite invoice or sales order. The flow updates the tax rate to 0% for all the order line items.
   
   Note: In the flow mappings, for the VA tax code mapping, 

   • if you select InternalId, enter the tax code in this setting with the NetSuite internal ID. Example: 8
   • If you select Name, enter the tax code in this setting in the VAT:Tax Code format. Example: VAT:UNDEF-GB
5. In the Map jurisdiction name to NetSuite tax code setting, enter a country code to map with the NetSuite tax code. This setting is applicable only if the order is not a marketplace facilitator order and if the EU One Stop Shop (OSS) box is unchecked in NetSuite. The flow updates the NetSuite tax code on the NetSuite invoice or sales order based on the jurisdiction name. 
6. In the Home subsidiary tax code setting, enter the home subsidiary tax code. This setting is applicable only if the, 
   • EU One Stop Shop (OSS) box is checked in NetSuite, 
   • ShipFrom country and ShipTo country are not the same, and 
   • ShipTo Country is your home subsidiary.
     The flow updates the OSS tax code on the NetSuite invoice or sales order.
7. In the Map ShipTo country code to NetSuite tax code setting, enter the ShipTo country code to the NetSuite tax code. This setting is applicable only if the, 
   • EU One Stop Shop (OSS) box is checked in NetSuite, 
   • ShipFrom country and ShipTo country are not the same, and 
   • ShipTo Country is not your home subsidiary.
     The flow updates the OSS-specific tax code on the NetSuite invoice or sales order.

Run the flow

Prerequisite: Before you run the flow, ensure that the invoice or sales orders are already synced to NetSuite using the Amazon (FBA/MFN) Order to NetSuite Order Add flow of the Amazon - NetSuite integration app.

Tip: The SC_VAT_TAX report is a daily recurrent report. It is recommended to schedule this flow with "Once Daily" frequency, so that flow picks all the VAT information of the Orders that are fulfilled before three days.

1. Go to Flows.
2. Next to the Amazon EU order tax details to NetSuite invoice or sales order flow, use the toggle button to enable the flow.
3. Click Run.
   After you run the flow, you can see the progress on the Flow Builder page.

Understand the records in NetSuite

Scenario 1

In this scenario, Amazon collects the taxes. Before you run the Amazon EU order tax details to NetSuite invoice or sales order flow, find the invoice record.

After you run the Amazon EU order tax details to NetSuite invoice or sales order flow, find the invoice record. The flow updates the tax code and tax rate. 

Scenario 2

In this scenario, the seller collects the tax. Before you run the Amazon EU order tax details to NetSuite invoice or sales order flow, find the sales order record.

After you run the Amazon EU order tax details to NetSuite invoice or sales order flow, find the sales order record. The flow updates the tax code.