Assign status details to Amazon inventory

You can assign inventory status for a line item that has different statuses. To assign inventory detail, you have to configure sub-record mappings to the following flows:

• Amazon (FBA) Order to NetSuite Order Add
• NetSuite Settlement Transaction to NetSuite Refund
• Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments
• Amazon Delivered Shipments to NetSuite Item Receipt

Before you configure your Integration App, enable the Inventory Status setting (Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab) in your NetSuite account. You can configure separate mappings for the inventory adjustments to know the status of inventory details lines.

Configure the sub-record mapping

1. Login to your integrator.io account.
2. Click on the Amazon-NetSuite Integration App tile.

Amazon (FBA) Order to NetSuite Order Add

1. Go to Flows > Order.
2. Click on the "Amazon (FBA) Order to NetSuite Order Add" flow to navigate to the “flow builder” page.
3. On the flow builder page, below "Amazon (FBA) Order Import Adaptor", click Import. 
4. Configure import settings:
   1. On the “Edit Import” window, below the “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from the "Which Cash Sale field should this subrecord set?" drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select items.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select NetSuite Credit Memo Import - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail: Status (InternalId)
      quantity	Inventory Detail: Quantity
      “true”	Inventory Detail: Replace All Lines

NetSuite Settlement Transaction to NetSuite Refund

1. Go to Flows > Refund.
2. Click on the "NetSuite Settlement Transaction to NetSuite Refund" flow to navigate to the “flow builder” page.
3. On the flow builder page, below "NetSuite Credit Memo Import", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from the "Which Refund field should this subrecord set?" drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select items.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select Amazon (FBA) Order Import Adaptor - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail: Status (InternalId)
      quantity	Inventory Detail: Quantity
      “true”	Inventory Detail: Replace All Lines

Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments

1. Go to Flows > Inventory (FBA) add-on.
2. Click on the "Amazon (FBA) Order to NetSuite Order Add" flow to navigate to the “flow builder” page.
3. On the flow builder page, below "Post Inventory Adjustments to NetSuite", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from the "Which Inventory Adjustment field should this subrecord set?" drop-down list, select Adjustments: Inventory Details.
   3. In the “Path to node that contains item data” option, select items.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select Post Inventory Adjustments to NetSuite - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail: Status (InternalId)
      quantity	Inventory Detail: Quantity
      “true”	Inventory Detail: Replace All Lines

Amazon Delivered Shipments to NetSuite Item Receipt

1. Go to Flows > Shipment (TO) add-on.
2. Click on the "Amazon Delivered Shipments to NetSuite Item Receipt" flow to navigate to the “flow builder” page.
3. On the flow builder page, below "Post Item Receipt to NetSuite", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from the "Which Item Receipt field should this subrecord set?" drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select items.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select Post Item Receipt to NetSuite - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail: Status (InternalId)
      quantity	Inventory Detail: Quantity
      “true”	Inventory Detail: Replace All Lines