Configure NetSuite custom fields to support Amazon Fulfillment API changes

Starting January 1, 2021, online marketplaces are responsible for charging and collecting VAT for sales to the UK from overseas selling partners to comply with the new VAT regulation announced by the UK government. As per the UK marketplace tax changes, Amazon MWS has updated the Amazon Fulfillment API to determine a selling partner's “Ship from address” information when confirming seller-fulfilled orders. If an order is shipped outside the UK marketplace, Amazon collects and remits taxes on their behalf. The Integration App is enhanced and updated to sync data to NetSuite as per the Amazon Fulfillment API changes.  

To support the Amazon Fulfillment API changes, you have to create the following custom fields in NetSuite:

• Name
• Address 1
• Address 2 (Optional) 
• Address 3 (Optional)
• City
• County (Optional)
• State or Region
• Postal Code
• Country Code

Note: The names provided for the custom fields are just an example. You can provide field names as per your business needs.

Step 1: Create custom fields for the above-mentioned fields

1. Login to your NetSuite account.
2. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.

1. On the “Transaction Body Field” page, enter the name in the Label field.
2. Select the appropriate field type in the Type drop-down menu.
3. In the “Applies To” tab, check the Item Fulfillment checkbox.
4. Click Save.

Note: Repeat steps 1- 6 to create all the above-mentioned custom fields. Provide appropriate names in the Label fields.

Step 2: Configure the fulfillment saved search to add the new fields

1. In NetSuite, in the global search bar, enter Celigo Amazon Fulfillment Export Search.
2. From the search results, select the appropriate saved search.
3. On the “Celigo Amazon Fulfillment Export Search” page, click Edit this Search.
4. Go to the “Results” tab
5. Click Add to add the newly-added custom fields as following:
   
   Note: The names provided for the custom fields are just an example. You can provide field names as per your business needs. 

   Field name	Custom Label
   Address Name (Custom Body)	Name
   Address1  (Custom Body)	Address1
   Address2 (Custom Body)	Address2
   Address3 (Custom Body)	Address3
   City (Custom Body)	City
   County (Custom Body)	County
   StateOrRegion (Custom Body)	StateOrRegion
   PostalCode (Custom Body)	PostalCode
   CountryCode (Custom Body)	CountryCode

6. Click Save.

Step 3: Configure the flow mappings

1. Sign in to your Integrator.io account.
2. Click Amazon - NetSuite Integration App tile.
3. Go to Flows  > Fulfillment. 
4. Next to the NetSuite Fulfillment to Amazon Shipment Add flow, click Mapping.
5. Add the following mappings in the specified order:
   

   Export field (NetSuite)	Import field (Amazon MWS)
   Name	Name
   Address1	Address1
   Address2	Address2
   Address3	Address3
   City	City
   County	County
   StateOrRegion	StateOrRegion
   PostalCode	PostalCode
   CountryCode	CountryCode

6. Click Save & close.